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