Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Form Design Tools-> Design-> Property Sheet

 

Link the Form and Subform

Earlier, you linked the Form and Subform by the Genre. You can add the Rating as the second Parent/Child Link.

 

Try it: Add another Subform Link

Open the MovieTitleSearch form in Design View.

 

Select the subform.

Open the Property Sheet.

 

Edit the Links. When you click either the Parent or the Child, the Subform Field Linker will open. Go to the second row and select Rating for both Fields.

 

Click OK and Save your changes.

\