Microsoft Access 2007: Have Access forms automatically close after use

If your users work with multiple Access forms, here’s how to make their work easier by having a form close automatically once they are finished with it:

1. Open the first form in Design view.
2. Double-click the Form Properties button.
3. Click on the Event tab.
4. Click in the On Deactivate text box.
5. Select Event Procedure.
6. Click the Build button.
7. At the prompt, enter: Me.TimerInterval =1.
8. Press ALT+Q.
9. In the Form Properties window, click in the On Timer property text box.
10. Select Event Procedure.
11. Click the Build button.
12. At the prompt, enter: DoCmd.Close.
13. Press ALT+Q.
14. Save the form.