Opening

  • Thread starter Thread starter renegade39
  • Start date Start date
R

renegade39

How can I set my database so that when I open the database a form will
automatically pop-up. I need to have one particular form pop-up evertime
that my database opens. Please help. Thanks.
 
Tools | Startup (exactly where depends on version of Access)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
The easiest way to do this is to make a mcr that has an openform in it
pointing to the form you want to open. When you save the Macro call is
AutoExec. Any macro named autoexec will executive automatically when the DB
opens.
 
You don't say what version of Access you have, but using 2003 as an
example, you would go to Tools/Startup/Display Form and select your
form there.

Alternatively, you could create a macro named AutoExec and use that to
open the form.
 
I just read the post mcr is Macro.

Dustin B said:
The easiest way to do this is to make a mcr that has an openform in it
pointing to the form you want to open. When you save the Macro call is
AutoExec. Any macro named autoexec will executive automatically when the DB
opens.
Click to expand...
 
Click the "Office" button (also affectionately known as the "belt buckle" in
the upper left corner).

Click the <Access Options> button at the bottom of the Office window that
popped up.

Select "Current Database".

Select the form you want to start with in the "Display Form" control.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top