Getting a form to open at database start-up

[PeterM]

Hey.

I want to have a form open as soonas I open up the database. It's called ControlForm and it allows me to navigate to other forms. How would I go about setting it up to open as soon as the database file is opened?

Thanks!

 

[Tezcatlipoca]

Two options:

1 - Macro
On the Objects menu, click Macros, then New. Use the dropdown list to select OpenForm, then set your required parameters in the box at the bottom of the window.
Finally, when you save the Macro, ensure you call it autoexec (very important).
When the database is next opened, this macro will automatically run, opening your form.

2 - Startup
Go to Tools, then Startup. On the right is a dropdown box that allows you to define which form will open first. Just select your form and away you go.

I personally prefer the macro route, as it offers me more control over what happens during my startups. I also add a layer of security to my databases which prevents the user from getting to Access behind (they can only access and navigate my forms), which I don't believe will work properly wit the Startup option.