Use the Subform Field Linker

2. Try it: Add Another Field

Select another Master Field: Genre

Select another Child Field: Genre

 

What Do You See? The Form and Subform are linked by two text Fields:

Rating matches Rating

Genre matches Genre

 

Click OK. Keep going...

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

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: Use the Property Sheet to Link the Subform