This article explains how to cause a form to open when an Access database is opened.

Step 1:

From the Create ribbon click on the Macro button:

The following window will open:

Step 2:

Select OpenForm from the drop down list:

Step 3:

From the Form Name drop down list, Select the form you would like to be opened when the access file is opened:

Step 4:

Save and close the macro window and rename it to “Autoexec”:

Note: By renaming the macro to Autoexec you are telling Access to run this macro when the file is opened.

Result:

Whenever the Access file is opened, “Form1” will be displayed:

Note: You could make the form a popup form so it will open similar to a regular windows form when the file is opened:

You can download the sample file used in this article from the link below:

• Open Form.Zip

See also:

• Open Blank Form When Database is Opened, Access VBA
• Access Create Popup Form
• Access Startup Form
• Opening or Initiating a Form with docmd.openform

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com