graphic1

Example of the Completed Search Form

Forms and Subforms:

Purpose of This Programming

The lessons will create a Search Form that lets Users look up Movies by the Genre and Rating.


The three Form and Subform lessons will program several Forms and Controls to:


Create a Form and Subform
Forms and Subform Design Part 1
will design two Forms: The MovieSearch Form and a MovieSearchSubform. The MovieSearch Form has a new Table for the Record Source. The Movie Subform will use a Query for the Record Source. Both Forms will be formatted and tested.


Link the Form and Subform
Forms and Subform Design Part 2
demonstrates how to link a Form and Subform. The Movie Search Form will use a Combo Box to filter the data in the Movie Subform.


Use a Query to Select Specific Data
Forms and Subform Design Part 3
adds a Synchronized Combo Box to the MovieSearch Form.

pic1