Change the Record Source

This Movie List is a copy of the Movie form you created for data entry. You also made a new query to use with this subform. Here are the steps to edit this subform so that it uses the new query.

 

Try it: Change the Record Source

Open the MovieTitlesList form in Design View.

 

Go to Design->Property Sheet.

 

Edit the Record Source: MovieTitleSearchSQ