Auto Open a Form at start up

[abc2002]

Hi, this is my first message on this forum. I hope that you can help me.

I want to know how to open a form automatically when a access database file is open.

Example:
I have a file: db.mdb
this file contains a Form named MyForm1.
When I open db.mdb, I want to see MyForm1 automatically.

In other words, I dont want to click on Forms and MyForm1 to open the form when I open db.mdb

Any idea what is the VBA code and where I put it (which functions...)

thank you

 

[Mile-O]

Goto Tools -> Startup and set the autoform to the form you want to open.

 

[sonny]

Once you have your db open got to the Tools menu at the top. From there select Startup.. You will see some boxes to fill out, one is for which form opens at run time...

 

[abc2002]

Thank you