How to open a form automatically in Access 2007 like a switchboard worked in Access 2002

[Cindy H]

Hi
Does anyone know how to open a form automatically when the user clicks on
the .accdb file in Access 2007?

In Access 2002 you could create a switchboard and then when the user clicked
on the .mdb file it would open the switchboard automatically. I'd like to
do the same thing in Access 2007, but instead of a switchboard, a form
opening.

Right now, I can't even figure out how to get the switchboard to open
automatically. If I click on the accdb file it goes into Access with the
forms on the left and no auto open for the switchboard.

Thanks,
CindyH

 

[Allen Browne]

You can define the form you want opened by clicking:
Office Button (top left)
Access Options
Current Database
Display Form

A macro named AutoExec containing the OpenForm action also works.

Just as a heads up, if you find your VBA code is not working in Access 2007,
you need to add your database folder to the trusted locations under:
Office Button | Access Options | Trust Center | Trust Center Settings

 

[Cindy H]

Ok, thanks

You can define the form you want opened by clicking:
Office Button (top left)
Access Options
Current Database
Display Form

A macro named AutoExec containing the OpenForm action also works.

Just as a heads up, if you find your VBA code is not working in Access
2007, you need to add your database folder to the trusted locations under:
Office Button | Access Options | Trust Center | Trust Center Settings