Microsoft Office XP - Load A Specific Form When A Database Opens (Access 2002)
When you finish creating an application, chances are that a particular form will receive the majority of the attention from users. If so, you can set up Access to automatically launch the form when the database is opened. To do so, choose Tools | Startup from the menu bar while the database is open. Then, choose the form from the Display Form-Page dropdown list. Finally, click OK. This technique can also be used to launch a form that acts as a splash screen or to open a switchboard form that acts as a user interface to your database objects.