Example of the Movie Subform with Conditional Formatting Form and Subform Design, Part 1: Create the Subform Key Concept: Using a Query as a Record Source   Plan: The Subform will display the Movies as a list in Datasheet view. The Rating data will be formatted with Conditional Formatting   What Are the Steps? Create a Select Query for the Record Source and Test the Results. Then, create a Subform and edit the Property Sheet.   What Are the Issues? The Subform should be in Datasheet View.   Why Use This Method? A Form can use either a Table or a Query for the Record Source.   A Query lets you select, sort and filter the Records in the Subform.