Hi - I have a database that loads a form when I open it. I went to Tools > Start up to see which form it was loading, but nothing was in the drop down under Display Form/Page.

I event went into the VBA immediate window and tried to query the CurrentDb property for StartUpForm (?CurrentDB.Properties("StartupForm")) but it gave me nothing (some sort of error message), as would be expected since the drop down had nothing in it.

The problem is, I'd really like to figure out how this form is loading on start up if it is not done the traditional way. Where would I even begin to look for this? I did a full VBA project search on the form name when I figured out which one it was and found no code in the project that opened it. I am perplexed!

Do you have an AutoExec macro defined?

I don't know, what is that and how do I check?

From the Database window click on Macros on the left side and see if you have one named AutoExec.

Ya, that was a stupid question, I didn't have the db in front of me so I wanted to make sure it wasn't hard to find. I found it and you were right. Thank you thank you!

So, is it just that if you create a macro called "autoexec" it will run when the db starts up? Is that a legacy thing? I had never heard of that before.

It has been there for quite a while. You can do things with the macro that just launching a form can't do.