Open A Specific Form When Document Opens

[Lois]

Hi
is there any way to set a form ao that it opens as soon as you open the database?

 

[ansentry]

Open you database then go to Tools/Start Up, then in "Display Form/Page" find and select the form you wish to open first.

 

[vbaInet]

Or you can use an Autoexec macro. John's suggestion is preferable though.

 

[Lois]

Maybe im just being stupid but where is tools / startup in access 07?

 

[ansentry]

Google is your friend, & it found it on this forum.

http://www.access-programmers.co.uk/forums/showthread.php?t=118483

 

[vbaInet]

You know the circle button at the TOP LEFT corner of the Access App?

Click that and click ACCESS OPTIONS > CURRENT DATABASE (on the left of the window that opens) > Select your DISPLAY FORM and click OK

 

[Lois]

Got it now..thanks