Example of the Rating Combo Box on the MovieSearch Form Form and Subform Design, Part 1: Create the Form Key Concept: Use a Combo Box Control to look up data in one Table and add it to another Table.   Plan: The Form will enable Users to search for Movies by Rating. This Form will have a new Table, tblMovieSearch, as the Record Source.   What Are the Steps? Create a new Table for the Movie Search Form. Create a new Form based on tblMovieSearch.   Create a new Table for the Rating data. Use tblRating as the Control Source for a Combo Box on the MovieSearch Form.   What Are the Issues? This Form should be in Single Form View.   Why Use This Method? A Combo Box Control is an effective way to look up the data in a Table. When a User selects a value from a Table it is accurate and spelled right.