Open Access Form with particular record displayed
Posted on 2014-02-26
I have an Access 2007 form that is opened (by default) on a new record. The code in the "On Load" event for the form is as follows:
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
What I would like to do is open the form, optionally, at a particular record. I cannot use the "gotorecord" method, because, as I read things, a value specified (instead of the acNewRec parameter), is an offset. I want to be able to go to a record based on a primary key value in a table used to populate the form.
Thanks for your help.