Expert: Scottgem - 7/9/2009

Question
I just started using Access 2007 a couple of months. My question is: how do I make the blank page that needs to filled with new data appear first of all when I open the data entry form? Presently, the first data automatically pops up and I have to click the rightmost arrow to make it appear.

Many thanks,
Max

Answer
Depends on how you want the app to work. Generally, forms are loaded from a menu system like a Switchboard. If you use the Switchboard Manager included in Access (under Database Tools) you can open a form in either Add or Edit mode. The Add mode opens to a blank form. This is a setting on the OpenForm method (or Action if you use a macro).

Alternatively you can have two forms, one just for data entry and the other for viewing and editing. If you set the Data Entry property of a form to use, it can only be used to add records.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA