Work with and Modify Subforms

Subforms rarely come out the way you want them to the first time: They may need to be resized so that they fit nicely in the main form. You may need to change the subform layout.

Work with Subforms

  1. In Form View, click a button on the subform's Record Navigation bar to add or move between records.
    Work with Subforms

Notice that the main form and subform each have their own set of navigation buttons that you can use to add.

Entering a record in a subform works just like entering a record in a main form.

Modify a Subform

Now let's try modifying a subform.

  1. Display the subform in Design View.
    Modify a Subform

    Access displays the form in Design View.

  2. Click anywhere in the subform to modify it.
  3. Edit the subform as needed.
    Modify a Subform

Then make the edits that you want.

The main form and sub form each have their own set of navigation buttons that you can use to add and move between records.

If you have set referential integrity between two or more related fields in a subform's underlying table or query, you will have to obey those referential integrity rules in order to add or edit a record in the subform. For example, you can't enter a number in the TourID field unless that number exists in the qryCustomerTours query.

Display a Subform’s Properties

Just like forms, subforms have their own set of properties that you can modify.

  1. In Design View, double-click the subform’s Form Selector.
    Display a Subform’s Properties

The subform’s properties are displayed in the Property Sheet pane.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.