Home Privacy Policy Feedback Link to us Site Map

Access: Convert GoToRecord macro to VBA code in Access 2003/XP/2000/97


Question:  In Access 2003/XP/2000/97, how can I convert a GoToRecord macro to VBA code?

Answer:  We'll demonstrate with the examples below.

Example #1

To convert the macro above to VBA code, you would use the following command:

DoCmd.GoToRecord acDataForm, "Work Order", acNext


Example #2

To convert the macro above to VBA code, you would use the following command:

DoCmd.GoToRecord acDataForm, "Work Order", acPrevious