A New Query for the List Form

The trick is to filter the list of movies in a subform to show only the Genre that matches the one selected with the Combo. You need to create a List Form, as well as the record source for that List Form.

 

The Movie table has some of the information. You also need data from tblGenre and tblRating. These are the steps to create a query to combine them together.

 

Try it: Create a Query for the Subform

Go to new Query in Design View.

Add tblMovieTitles, tblGenre, and tblRating at the Show Table Window.

 

Create a Join from:

tblMovieTitles.Rating to tblRating.Rating

tblMovieTitles.Genre to tblGenre.Genre