Auto-open a form or other Access object 1

[shauntwo]

Hi,

I believe this is a simple command - at least it is with Excel VBA, but what kind of code will automatically open a particular form upon opening an Access database? I thought it had to do with the way you declare the procedure name (i.e., Sub Autpen), but I'm not so sure.

Thanks for your help.

Shaun

 

[JeremyNYC]

Two ways:
1) Write a macro called AutoExec. It will run when you open your database. You can open a form, call code, or do whatever you want from there.
2) In the Tools menu, choose Startup. There you can choose a startup form. You can run code or whatever from the open or load or current event of that form.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[shauntwo]

Thanks Jeremy - that was easy enough.

Shaun