Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 The Indie Scene Independent Investigations Click Here to Get Started Sample Files Advanced Access Lesson Objectives: Learn how to create a search form. This lesson will demonstrate how to modify the relationships between tables in a query and use that query to filter the subform. In this lesson you will: Define the fields for the Search Table Page 4 Practice the steps to copy and edit the Movie Form Page 5 Use a query for the List Form Page 9 Review and edit the Join Properties Page 10 Identify the steps needed to create a List Form Page 12 Use the Property Sheet to change the Record Source Page 14 Use the Controls to add a Subform Page17 Use the Home Ribbon to Refresh the Record Page 19 Learn how to program the AfterUpdate() Event Page 21
Click Here to Get Started
Sample Files
Advanced Access
Lesson Objectives: Learn how to create a search form. This lesson will demonstrate how to modify the relationships between tables in a query and use that query to filter the subform. In this lesson you will:
Define the fields for the Search Table Page 4
Practice the steps to copy and edit the Movie Form Page 5
Use a query for the List Form Page 9
Review and edit the Join Properties Page 10
Identify the steps needed to create a List Form Page 12
Use the Property Sheet to change the Record Source Page 14
Use the Controls to add a Subform Page17
Use the Home Ribbon to Refresh the Record Page 19
Learn how to program the AfterUpdate() Event Page 21