In Access desktop databases you can use the GoToRecord action to make a record on a hidden form the current record if you specify the hidden form in the Object Type and Object Name arguments. To run the GoToRecord action in a Visual Basic for Applications (VBA) module, use the GoToRecord method of the DoCmd object. In Access desktop databases you can use the GoToRecord action to make a record on a hidden form the current record if you specify the hidden form in the Object Type and Object Name arguments. To run the GoToRecord action in a Visual Basic for Applications (VBA) module, use the GoToRecord method of the DoCmd object. While there are other ways to perform operations on records in a form or subform, using RecordsetClone is by far the fastest and easiest method. For more information include a function to call, visit our paper Resyncing a Subform Record in Microsoft Access.

I have a form with a 'View' button on it that will open up a continuous form (which looks like a datasheet) which simply lists all the records from the same query as the original form. Hello! I have a form (Form2) which is being opened (or sometimes set focus to) from another form (Form1). On the open and gotfocus events, I want it to go to a new record; however, I also want it to be able to see/edit previous records (so the DataEntry mode option is right out).