Microsoft Office® Access 2007 Inside Out

Adding Records and Changing Data

You’ll probably design most forms so that you can insert new records, change field values, or delete records in Form view or in Datasheet view. The following sections explain procedures for adding new records and changing data.

Adding a New Record

The procedure for entering a new record varies depending on the design of the form. With a form that’s been designed for data entry only, you open the form and enter data in the (usually empty) data fields. Sometimes forms of this type open with default values in the fields or with data entered by a macro or Visual Basic procedure. In the Conrad Systems Contacts application, frmCompanyAdd and frmContactAdd are two examples of forms that open in Data Entry mode. You can ...