Close Forms

Auto Shutdown

Here's how to close a form after it’s used:

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.
   (Try something like 30000 milliseconds)
   
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.

TechRepublic


See all Topics