Example of the Form and Subform Links in the Property Sheet Form and Subform Design, part 2: Link the Form and Subform Key Concept: Use a Form Control to add the MovieSearchSubform to the MovieSearch Form.   Plan: Link the Form and Subform by three Fields to create a one-to-many relationship.   What Are the Steps? Use the Subform Wizard to Link the Forms Select the Subform Define the common Field: Rating   Review the Subform Properties Confirm the Master and Child Links Test the Movie Search Form   Automate the Form with a Macro Troubleshoot the Programming   What Are the Issues? The Control Automation will be programmed with Embedded Macros. The new Macro Editor uses forms to help write the Code.