Repeat header of subform on next page

[SoggyCashew]

Hello I have a report with a subform and in this subform I have a report
header I want to repeat to the next page if there is a next page. How is this
done? Also I want to insert page numbers but I have tried to use the page
footer and it doesnt show up what do I do for that as well?

 

[John Spencer]

First of all you should not be using a subFORM on a report. You should be
using a subREPORT on a report.

The report controls the headers and footers. If you want to have repeated
header information for the subreport:
Add a top-level group (View: Sorting and Grouping) to the sub-report
Field/Expression value set to =1
GroupHeader set to Yes

Then put what you want to see on each page into the GroupHeader
Set its Repeat Section Property (on the format tab) to Yes.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[SoggyCashew]

John it is a subreport "Typo" what your saying is in my subreport create a
new Field/Expression in the subreports Sorting and grouing and name it =1
then in the group properties under group header select "Yes" then the test I
want to see on each page in my subreport I need to put into the new area it
created on my report. Now after that I dont understand what to do because I
cant find a Repeat Section Property (on the format tab)? I select the
properties of the group header and there is a keep together and its already
set to yes but it still doesnt work. Thanks!

 

[SoggyCashew]

Sorry John, I found it... I looked at it 10 times and never saw it!