Hello, This is my first post, so I hope I have posted it in the correct place.
I found the following Q&A in the archives from 2004:
"Mei Qin" <email@example.com> wrote in message
> I have a main report contains 8 subreports. The main
> report is just the place holder with some header
> information. I want to display each subreport on a new
> page. This works fine when subreport has data. But it give
> me a empty page when a subreport with no data. How can I
> get rid of this empty page when there is no data on a
> Thanks for any help!
Name your page break controls so you can refer to them in code. Then use
Me.pgbrkOne.Visible = Me.subrptOne.Report.HasData
MS Access MVP
I was having the exact same issue and the solution worked wonderfully with one exception. In my report the first subreport prints directly after the headers and so does not have a pagebreak before it. So, if there is no data in the first subreport, then my first page of the report has the Page headers and footers, but the detail is blank. I would appreciate any suggestions on how to fix this.