MS Access 2007: Automatically start up a form when database is opened
This MSAccess tutorial explains how to setup a form to open automatically when a database is opened in Access 2007 (with screenshots and step-by-step instructions).
See solution in other versions of Access:
Question: In Microsoft Access 2007, how do I set a form to appear when I first open the program?
Answer: To automatically start up a form when the Access database is opened, click on the Microsoft Office button 
in the top left of the Access window and then click on the Access Options button.
When the Access Options window appears, click on the Current Database tab. Then in the Display Form drop down, select the form that you wish to open at startup. In this example, we have selected the form called frmProducts.
Click on the OK button.
Now when you open your Access database, the frmProducts form should start up automatically.
Advertisements