Link the Form and Subform

The MovieSearch Form is already linked to the Subform by Rating. Now, we need to link the Forms by Genre as well. Here are the steps.

 

1. Try it: Select the Subform

Select the Subform. There should be a yellow border around it and the Property Sheet should indicate that a Subform/Subreport is selected.

 

Try This, Too: Review the Subform Properties

The Subform Properties include:

Name: MovieSearchSubform

Link Master: Rating.

Link Child: Rating.

 

Click on Rating. The 3-dot Builder should be available, now.

 

Click on the 3-dot Builder. Keep going...

Form Design Tools->Design->Tools->Property Sheet

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: View the Property Sheet