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:
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:
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