subreport labels on next page

  • Thread starter Thread starter Mary Ann
  • Start date Start date
M

Mary Ann

I've created a report with 7 subreports. When the
subreport data goes to the next page, how do I repeat the
subreport label?

Thanks for your help.
 
Thanks for the information. I'm still lost. I've inserted
the subreports in the detail section of a blank report.
I'm kinda new to Access, and don't understand your
explanation.

Thanks for your help.
 
Mary said:
Thanks for the information. I'm still lost. I've inserted
the subreports in the detail section of a blank report.
I'm kinda new to Access, and don't understand your
explanation.
Click to expand...

Open the report in design view. The Sorting and Grouping
window is opened from the Virew menu. Enter =1 in the top
line under Field/Expression. In the lower part of the
window, enter Yes in the Header row.

Then go to the report design area and you'll see there is
now an =1 group header section. Put your labels there.

When the header section is selected, use the View menu to
display the Properties window. Look through the list of
properties and set Repeat Section to Yes. Save the report
and then test it.
--
Marsh
MVP [MS Access]

 
Back
Top