Solved: Open particular form on starting Access

[gsanghvi20]

Hi,

I want a particular form to be open (frmMain) when I open the particular Access program, so that the user does not have to search the specific form from the Navigation pane. How can this be done.

Please :help

Thanks,
gsanghvi20

[CreganTur]

This is very easy- Access has a Startup panel where you can setup options you want for startup.
WARNING: when the security box appears when you open your database, holding shift while clicking open will bypass your Startup selections and take you straight to the database window.

Click on Tools -> Startup... and make your selections.

[OBP]

It can be done in 2 ways, the first is to go to the main menu Tools>Startup and select the form you want to start with.
The second method, which is more versatile involves Creating a macro to open the Form and Calling it Autoexec.
Any macro called Autoexec runs when the database is opened.

[gsanghvi20]

Thanks guys :)