What Does the Form Look Like?

Try This: View the Movie Search Form

Go to Form Design Tools->Design->Views.

Select a View: Form View.

 

The purpose of this Form is to filter the movie list by Rating. There are many Movies in the database that have the same Rating.

 

Microsoft Access represents a one-to-many relationship (one Rating, many Movies) with a Form and Subform.
 

The key to making the Forms and Controls work is reviewing the Properties.

Form Design Tools->Design->Views->View