Say someone wanted to lookup only PG13 rated movies. The Rating Combo Box that we programmed filters the MovieSearchSubform and displays all of the PG13 movies. You can add a second Combo Box that only shows the Genres for PG13 Movies. The Genre Combo would look up the Rating, PG13, and display all of the comedies that have a PG13 Rating. The two Combo Boxes are said to be synchronized because the first Combo Box sets the criteria for the second. This lesson creates the Genre Combo Box and programs it to look up the Rating on the Movie Search Form.

Synchronized Combo Boxes

 

Microsoft Access 2010: Example of a Form with two, synchronized Combo Boxes