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.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.