I want a main form to activate when I open the database

[Fernandello]

I want a main form of my database to activate when I open the database. It
should be the initial form that is immediately there and maximized. How do I
set up such a form?

 

[Linq Adams via AccessMonster.com]

In the form's Form_Load event place:

DoCmd.Maximize

Then in Design View goto Tools - StartUp and in the "Dispaly Page/Form" box
select the form.

Now, to prevent a future post by you:

When you need to get into design mode, i.e. bypass the form automatically
loading, press and hold down the <Shift> key then, still holding <Shift> down,
open your database. Keep holding <Shift> down until yopu see the Objects
Dialog box.

 

[Rick Brandt]

I want a main form of my database to activate when I open the database.
It should be the initial form that is immediately there and maximized.
How do I set up such a form?

In versions prior to Access 2007 use Tools - Startup. In 2007 the same
functionality is there but I don't know where it is.

 

[RoyVidar]

In versions prior to Access 2007 use Tools - Startup. In 2007 the
same functionality is there but I don't know where it is.

In 2007 version - Office menu | Access Options, the Current Database
category, select the correct form in the Display Form dropdown.