What Are the Objectives?

Both the Form and the Subform have a Rating Control, which is Text. First, we will confirm that both Forms have the same Field. Then, we'll use the Subform Wizard to walk through the steps.

 

Review the Form and Subform

Open both Forms in Design View

Identify the Record Source

Confirm the Default View

 

Use the Subform Wizard to Link the Forms

Select the Subform

Define the common Field: Rating

 

Review the Subform Properties

Confirm the Master and Child Links

Test the Movie Search Form

Automate the Form with a bit of code (a Macro!)

 

Troubleshoot the Programming

Review the Form and Control Properties

Review the Master and Child Links 
Review the Embedded Macro

 

That's the plan. That's a lot...maybe not    ;-D

Microsoft Access 2010: Example of a Form Control with a Macro