Open Form When Database is Opened, Access

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


Contents

Step 1:

From the Create ribbon click on the Macro button:
Macro
The following window will open:
Macro, Dialog


Step 2:

Select OpenForm from the drop down list:
OpenForm


Step 3:

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


Step 4:

Save and close the macro window and rename it to “Autoexec”:
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:
Result
Note: You could make the form a popup form so it will open similar to a regular windows form when the file is opened:
Popup Form

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

See also:

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

Leave a Reply

Your email address will not be published. Required fields are marked *