Access 2010: Representing One-to-Many

Forms and Subform Design, part 2


Intermediate Access Objectives

In this lesson, you will learn how to:

1. Review the Properties for a Form: Record Source, Controls, View.

2. Use the Subform Wizard to add a Subform to a Form and link them by a common Field.

3. Create a Combo Box to filter the Records in the Subform.

4. Add a Macro to Refresh the Records in the Subform when the Combo Box is changed.