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...

Create ->Queries ->Query Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships: Use the Show Table Command