Access 2016 Advanced

Access 2016

Lesson 1 - Using Subforms/Subreports

the wizard if you are designing a subform/subreport that is very different in appearance from the form or report the wizard produces.

C REATING A S UBFORM /S UBREPORT



Discussion

When you add a subform/subreport to an existing form, it is best to start by creating the main form/report before you create the subform/subreport. Then edit the form/report so that it contains only the information you need, as well as the desired layout. Add the form/report to the main form/report design where it will take on the properties of a subform or subreport.

Create a subform that may be viewed in Form view, Datasheet view, or both views. You can create a subreport that may be viewed in Preview view. Customize the subform in Design view by adding items such as headers, footers, color, fonts, and totals.

The SubForm/SubReport Wizard prompts you for the following information:

1. Whether to use an existing form/report as the subform/subreport or build a new one from tables and queries. 2. If you want to define the link between the main form/report and subform/subreport yourself or choose from a list of available link options. 3. A name for the subform or subreport.

OFFICEPRO, Inc.

Page 3