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
Made with FlippingBook - Online magazine maker