Only show a subreport under certain circumstances?

[TonyWilliams via AccessMonster.com]

I have a report (rptlinesbycountry) that is run twice a year in June and in
December which includes a date control txtmonth (I realise the txt prefix is
a little misleading but the field is definately a date field). The report
contains a sub report (rptlinesbycountryYTD) that I only want to be shown
when the report is run in Decemeber. How do I code the report for that to
happen?
Thanks
Tony

 

[Marshall Barton]

I have a report (rptlinesbycountry) that is run twice a year in June and in
December which includes a date control txtmonth (I realise the txt prefix is
a little misleading but the field is definately a date field). The report
contains a sub report (rptlinesbycountryYTD) that I only want to be shown
when the report is run in Decemeber. How do I code the report for that to
happen?

Use the Format event of the section containing the
subreport:

Me.subreportcontrol.Visible = (Month(Date) = 12)

Make sure the subreport control and its section both have
their CanShrink property set to Yes.

 

[TonyWilliams via AccessMonster.com]

Thanks Marshall that worked just fine.
Tony

Use the Format event of the section containing the
subreport:

Me.subreportcontrol.Visible = (Month(Date) = 12)

Make sure the subreport control and its section both have
their CanShrink property set to Yes.