Access Report/Subreport paging problem

[FrustratedCoder]

Hi everyone,

I have a report which contains several sub-reports. None, One or more sub-reports may be displayed, depending upon a field in the main report.

Each of the sub reports may contain zero or more pages, with forced page breaks required according to groupings.

When a sub-report requires displaying, if there are no records in the sub-report no page should be displayed.

The problem I have is that in this instance, I am getting a page displayed showing nothing but the page footer.

I have tried limiting the source of the main report to only those records that have corresponding records in the sub-reports but I still seem to be coming unstuck.

I am using Access 97 by the way

Thanks in advance for any help