Software Developer's Resources

How to set startup form (Access 2007)

You can set a form to execute upon startup in two ways:

• Display Form under Applications Options.
• AutoExec macro.

Display Form Under Application Options

1. Click Office button.
2. Click on Access Options (at bottom of Office menu).
3. Click on Current Database.
4. Under Application Options find Display Form drop down list.
5. Select desired form.
6. Close and open Access

AutoExec Macro

You can cause a form to open in the AutoExec macro.

Access runs the AutoExec macro when the user opens the Access application.

1. Open Navigation Pane.
2. Locate AutoExec macro.
3. Right-click AutoExec macro and select Design View.
4. Insert an OpenForm action.
5. Enter the desired startup form in the Form Name action parameters field.
6. Save and close the macro.
7. Test the change by closing and opening Access.

One or the Other, but Not Both

You should use one method for opening the initial form.