MS Access: Automatically start up a form when database is opened in Access 2003/XP/2000/97
Learn how to automatically start up a form when database is opened in (other versions of Access):
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.