How do I Remove the sub-report page if it has NO-DATA

[Guest]

I have created a report having two sub-reports in it, to view sub-reports in
seperate page I use page break after sub-report, and in the sub-report's NO
DATA property I code Me.Report.Visible = False.
when I view the report it shows blank page of sub-reprt where the sub-report
has no data.

I want to know how to remove the page from the report if the sub report has
no data.

 

[Arvin Meyer [MVP]]

You might try using the KeepTogether property with or instead of the page
break. Setting this property to True for a Group or Section forces all or
at least as much as possible to the next page if it won't fit on the first
one. Use the On NoData event to set the subreport control height to 0 if
there is no data, ensuring that a new page won't be forced.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access