Forms and Subform Design, part 1 defined the scope of the programming: we wanted to search the movies by Rating. This is a one-to-many relationship. Microsoft Access represents a one-to-many relationship with a Form and Subform. The Movie Search Form stores the Rating in a new table, tblMovieSearch. The Movie Search Subform lists the movies that match that criteria. It looks up the movies with a Select Query based on the movies Table: tblMovies.

 

Forms and Subform Design, part 2  links the Form and Subform by a common Field: Rating. This lesson walks through the steps and offers some options for troubleshooting the programming. Let's get started.

Access 2010: Example of the completed Form and Subform

Forms and Subform Design, part 2