In many databases, it is helpful to have the same form open automatically every time that you open the database. To set the default startup form, you specify the form in Access Options.
Specify the default form in Access Options
This procedure assumes that you have a database open and that you have already created the form that you want to display.
Click the File tab, and then under Help, click Options.
Click Current Database.
Under Application Options, in the Display Form list, select the form that you want to display when the database starts.
If the database is to be published as a Web database, in the Web Display Form list, select the form that you want to display as the default form in the browser.
Note: To bypass this option and other startup options when opening the database in Access, hold down the SHIFT key while you open the database.