This MSAccess tutorial explains how to setup a form to open automatically when a database is opened in Access 2003 (with screenshots and step-by-step instructions).
Question: In Microsoft Access 2003/XP/2000/97, how do I set a form to appear when I first open the program?
Answer: You need to reconfigure the settings in your Startup options. Under the Tools menu, select Startup.
When the Startup window appears, set the "Display Form/Page" option to the form that you wish to open at startup. Then click on the OK button.
Now when you open your Access database, the Suppliers form should start up automatically.
(scroll to see more)