ACCESS 2003 repeat header on all pages on a sub report from a main report

eyes59
eyes59 used Ask the Experts™
on
I have a subreport in a main report.  I want to repeat the page header on all the pages in the subreport.  I know I can't put anything in the Page header section of the subreport if I want it to be seen from the main report.  How do I set up the subreport so the page header appears on all pages of the subreport AFTER the subreport is dragged into and opened from the main report
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Take a look at the solution here to the same question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21585927.html

(That's the first 'Accepted Answer' I got on EE, in 2005 :-)  )
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
"Use a group header and set the RepeatSection property to Yes in the group header's property sheet."
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:

 AH, you beat me to it.  

  BTW, for the headings, just add a dummy group with the expression:

=1

 Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial