Microsoft® Access® 2010 24-Hour Trainer

35

Working with Subforms and Subreports

Subforms and Subreports are used every day in Access 2010. The Subform/Subreport control enables the developer to show other database objects directly from within the parent form. The Subform/Subreport control is extremely flexible and provides a lot of functionality for working with subobjects, as you will see in this lesson.

LESSON SETUP

This lesson is designed to provide an overview of working with Subforms and Subreports in Access Forms. Now that you have a basic understanding of working with Access Forms, you will explore the Subform/Subreport control to illustrate how easy it is to work with the visual controls of Access.

SUBFORMS/SUBREPORTS IN ACCESS

Access Subforms and Subreports are nothing more than object frames that can be used to display other database objects. Like forms, Subforms and Subreports can be Bound or Unbound, depending on what functionality is desired. Binding the control really only means that the Object Source property has been set to some valid database object. The Subform/Subreport control can be bound to tables, queries, forms, reports, PivotCharts, and PivotTables.

The type of database object that is bound to a Subform/Subreport determines the view for what is to be displayed in the Subform/Subreport control. In the case of a table or query, the default view is the Access Datasheet View, showing the data that would be shown in that object. For a report, PivotChart, or PivotTable, the default normal view for ...