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

  • Thread starter Thread starter Cindy H
  • Start date Start date
C

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
 
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
 
Ok, thanks

Allen Browne said:
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
Click to expand...
 
Back
Top