Form opens even when not specified in Startup

[JohnB]

Hi.

OK, this is probably very simple but I can't see it.

I have a small mdb that I wanted to experiment on, by converting it to
Access 2007. So the first thing I thought was to remove the feature that
opens a main form on Startup. So I go to Startup and nothing is specified!
I've looked in the Event code of the form in question and only a Maximise on
open event exists. I've tried introducing a different form in Startup and
they both open.

Can anyone tell me what could be causing this form to open, if it's not
specified in Startup? I think the answer is going to embarrass me.

Thanks,

 

[Jeff Boyce]

John

Check the "Macros" tab -- do you have one named "AutoExec"? Whatever's in
that will automatically execute on startup.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[JohnB]

That was it Jeff, thanks.

In my defence I should say that this is not one of my designs - I only got
involoved when the users wanted some reports put together. I think I'll
remove the Autoexec function and revert to the Startup feature - much more
visable for something that's very simple.

Thanks again.

 

[Douglas J. Steele]

Just make sure that the AutoExec macro isn't doing anything else in addition
to opening the form before you delete it.

 

[JohnB]

Sorry, just spotted this Doug. Thanks, will do.

Cheers.