AboutScottgem Expertise I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
Experience I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.
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
