OK, I did that. There were two messages that showed up on Google
Groups for this group: the response to my original post and another one
that had nothing to do with subreports. Help made no mention of doing
this for a subreport and Googling brought up a lot of stuff on how to
do totals in page footers. None of them help me.
I don't know how to do this. Would someone please take the time to
explain, in words of one syllable or less, how I can do this?
I tried the following in the DateFooter section that runs the
subreport, but no luck. The format event for DateFooter will fire, but
no change is made to the pageheader. Combo122 and lblMonthly are both
in the Parent report :
Private Sub DateFooter_Form at(Cancel As Integer, FormatCount As
Integer)
Me.Combo122.Vis ible = False
Me.lblMonthly.V isible = True
End Sub
TIA
Neill
Look at the Format event of the PageHeaderSecti on and
PageFooterSecti on in Help and in this newsgroup.
Darryl Kerkeslager
"neill dumont" <neill.dum...@g mail.com> wrote:
I have a report in front of an aggregate query. I have a single
subreport based on the same query for both a month/year group and
for grand totals (linked on month/year) .
Instead of the name of the program and the month/year, I would like:
- a label on the report header to read "Monthly Summary" with the
month & year when the subreport is printing for the footer of the
month/year group and
- a label on the report header to read "Overall Summary" when the
subreport is printing for the report footer.
I guess what I'm asking is how do I "sense" what report section I'm
viewing/printing a page from?