Access 2007 FAQ
How can I designate one form to always open when someone opens the database?
Yes you can do this, and in fact, you have several options. You could use a macro or VBA code to open a specific form when someone opens the database. On this page we'll show you how to use the Access Options to designate a startup form.
First, you'll need to open the Access Options dialog box. If you need help with that, please see the following page: Related Topic
Now that you have the Access Options dialog box open, click the Current Database category on the left side. Under the Application Options section, click the arrow on the Display Form option and select the form name you want to use as the startup form, as seen in the following screenshot.
Click OK to save your changes and close the Access Options dialog box. The next time you or someone else opens the database, Access opens that form.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page