Link a Query to a Form

One query filters the next. You can make the rating query on the MovieTItlesList (the subform) lookup the Genre from the MovieTitleSearch form (the Master form).

 

Try it: Program a Form Reference

Open RatingSearchSQ in Design View.

 

Select the Genre field and delete the criteria: Is Not Null. Now, right click the Criteria to Build an expression.