Need some input, guys!
I've got a report where the main report is a dynamic cover letter. There are three subreports in the main report's ReportFooter. They were (key word being were) all one pagers so I was able to make each individual subreport's ReportHeader act as a Page Header. Well, the last subreport has now gone to 2 pages so there is no header on it's second page.
I had the idea of placing the final report's header in the main report's unused PageHeader, initializing it as not visible and changing it to visible on the final page of the last subreport.
Clear as mud, yet?
Well, in theory good, but, how do I reference the Visible property of the main report's PageHeader and change it? I can do this for an individual control but what about the entire PageHeader section?
BTW, I am using Access 2003. And need quick input.