How do I get a form to load on startup

[Ciarán]

I know the answer to this must be sipmle, but I can't find it.

If I have a form called frm_Main what code do I use to load it when
the DB is opened and where do I put this code?

Regards,
Ciarán

 

[Jeff Boyce]

Ciarán

You don't mention which version of Access you are using, so the answer may
not fit your version (the concept is the same, the specifics may vary)...

One of the database's properties is the "startup form" you wish Access to
use when in opens your application. Set that to your "frm_Main".

Regards

Jeff Boyce
Microsoft Office/Access MVP


I know the answer to this must be sipmle, but I can't find it.

If I have a form called frm_Main what code do I use to load it when
the DB is opened and where do I put this code?

Regards,
Ciarán

 

[Ciarán]

Hi Jeff,

I'm using Access 2007 with Vista and cannot find the the startup form,
can you give guidance?

Regards,
Ciarán

 

[Jeff Boyce]

Click the 'belt buckle' in the upper left hand corner.

Click <Access Options> at the bottom of the screen.

Select the "Current Database".

Use the "Display Form" combobox to select your form.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff,

I'm using Access 2007 with Vista and cannot find the the startup form,
can you give guidance?

Regards,
Ciarán

 

[Ciarán]

perfect, cheers.