Example of a Query that synchronizes two Combo Boxes Form and Subform Design, part 3: Synchronized Combo Boxes Key Concept: Use the Query Criteria to look up a value on a Form.   Plan: Synchronize two Combo Boxes and Filter the Records in the MovieSearchSubform.   What Are the Steps? Create a Table for the Genre. Create a Query for the second Combo Box. Use the Expression Builder to write a Criteria that looks up a Field on the MovieSearchForm.   Create a Genre Combo Box Automate the Form with a Macro Test the Movie Search Form Troubleshoot the Programming   What Are the Issues? Many of the Movie Records are incomplete: they have no Genre data. So, the Query needs to filter out the Movies that do not have a Genre with a Criteria.