Form opening on start up

[Gwill1983]

Hi all,

I have a few forms within my database and I cannot get it to stop opening a certain form on startup

I have been through the options to set my MENU form as being the one to open on start up (Current Database - Display Form) which it does, but there is also another form that opens every time I start up access as well!

I don't want anything to open except the menu form.

Has anybody had this before and know how to stop it?

Thanks

Chris

 

[welshgasman]

No.
Check your code.
Put a breakpoint on the first form and walk through the code.

Search for the name of the errant form in your project.

 

[Joe4]

Do you have a macro named "AutoExec" in your database?
If so, that will run automatically whenever your database is opened.
This could be what is opening the other form.

See here: Create a macro that runs when you open a database

 

[Gwill1983]

Perfect! Deleted the macro and the problem has gone away. Thanks again for your help

 

[Joe4]

You are welcome.
Glad we were able to help.

BTW, in the future, in case you want to keep whatever was in that macro, you don't actually need to delete it.
If you name it anything other than "AutoExec", it will not run automatically upon opening.