Access: Convert Close macro to VBA code in Access 2003/XP/2000/97
Question: In Access 2003/XP/2000/97, how can I convert a Close macro to VBA code?
Answer: We'll demonstrate with the example below.

To convert the macro above to VBA code, you would use the following command:
DoCmd.Close acForm, "Engineering", acSaveYes
This command would close the form called Engineering and save any changes.