Forms and Subform Design, part 3

Synchronized Combo Boxes

Access 2010: Representing One-to-Many

 

Intermediate Access Objectives

In this lesson, you will learn how to:

1. Create a Select Query to filter the Records in the Subform.

2. Use the Expression Builder to write the criteria that looks up the data on a Form and synchronizes the two Combo Boxes.

3. Use the Combo Wizard to add a Drop Down Control based on the Select Query.

4. Add an Event Procedure in Visual Basic to Refresh the Records in the Subform when the Combo Box is changed.