Editing Form Records

In Access XP editing form records may seem confusing at first. This free lesson offers step-by-step instructions.

Editing form records

Information will undoubtedly change in your database. Contacts move to a different address, change their telephone numbers, and switch companies. You can either change the information for any of these records, or if they're no longer needed you can delete a record from the database.

Editing a form record in Access is easy. It entails locating the record and then typing the corrected information in the appropriate field.

To edit a form record:

  • Using the status area to navigate the forms, display the form record that will be edited.

    Status Area
  • Click in a field or use the keyboard to navigate to the first field to be changed or added.

    Contacts Form
  • Type the new information or correct the information in the selected field.
  • Navigate to the next field that needs to be corrected and make any necessary changes.
  • When you're finished editing information on this page, click the Page 2 button to display additional fields.

    Contacts Form

In the previous lesson, we saw how to enter new contact types on the Contact Types form. These entries are now available for use in the Contact Type field of the Contacts form.

  • Click the drop-down button associated with a contact type. If you successfully completed the challenge in the last lesson, this drop-down list now contains several entries: Family, Friend, Relative, Work, Recruiter, Company, and Network.

Saving your work: After you input the data into a form record, Access automatically saves the record when you use the mouse, an arrow key, the Tab key, or the Enter key to move the cursor out of that field and into a different field or record.

You can always add records to the Contact Types table while in Datasheet view. Click the Tables tab from the Objects palette of the database window, then double-click the Contact Types table to open the table in Datasheet view.