Create a Record Source
for the Movie Subform
The
Subform will be a list of the movies. It will look like a Datasheet.
The Record Source for this new Subform will be a Select Query that
uses tblMovies.
1.
Try it: Create a Query
Go to
Create ->Queries ->Query Design.
You will
be prompted by the Show Table. Select a Table: tblMovies.
Click
Add. Keep
going...