Data Management

Display a specific form when your Access 2007 database is opened

If you want to prevent your users from navigating around your database, you can configure Access 2007 to take them straight to a designated form.

You don't want your users navigating your Access 2007 database on their own. Instead, when they open the database, you want them to access the data, reports, and queries through controls on the opening form — not the navigation pane. Follow these steps:

  1. Open the database.
  2. Click the Office button and then click the Access Options button.
  3. Select Current Database from the left pane.
  4. Under Applications Options, click the Display Form drop-down list and select the form you want to display when the database is opened.
  5. Under Navigation, clear the Display Navigation Pane check box (Figure A) and click OK.

Figure A

Now, when users open your Access database, they will see only the selected form in the Display Form box. The navigation bar will not be visible.

Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox