Work with and Modify Subforms
How to Work with and Modify Subforms in Access
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
- In Form View, click a button on the subform's Record Navigation bar to add or move between records.
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.
- Display the subform in Design View.
Access displays the form in Design View.
- Click anywhere in the subform to modify it.
- Edit the subform as needed.
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.
- In Design View, double-click the subform’s Form Selector.
The subform’s properties are displayed in the Property Sheet pane.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
You Get:- LinkedIn-ready certificate
- Skill assessments
- Bite-sized, interactive lessons
- Saved progress
- Display the subform in Design View.