Access 2003 Subreport page break

[aarondorsey]

I have seen similar questions on this, but none of the solutions work
for me.

I have two reports: ReportMain and ReportSub

When opening ReportSub, I get 49 records, 5 per page, using a page
break in the detail section under the field (works fine)

When opening ReportMain which has ReportSub as a subreport in the
detail section, the page break no longer works


It does not work even when both breaks visible at all times, so is
there another way?


I have tried using a page break below the subreport in ReportMain

I am using the onformat event to make the pagebreaks visible via global
vars:

pseudo...

sub detail_format
If reportmain.thecounter Mod 5 = 0 Then
reportmain.pagebreak.visible = true
reportsub.pagebreak.visible = true
else
reportmain.pagebreak.visible = false
reportsub.pagebreak.visible = false
end if
end sub

Any thoughts are greatly appreciated.

Regards, Aaron

 

[Duane Hookom]

There are no page events or sections or controls in subreports. What are you
attempting to do and why?

There could be a solution that involves creating numbered groups of 49
records each in your subreport's record source.

 

[aarondorsey]

The 49 records is the result of the query that is used to produce
reportsub (i.e. it is correct, no problems).

I only want five records from that query (which displays fine in
reportsub) to be shown on each page in reportmain. I am using
subreports because I will actually be displaying four subreports on
reportmain.

Using MOD 5 in reportsub shows the 5 recs per page when opened, but
when reportmain is opened, it displays all 49 recs over about five
pages...10 recs per page... until the recordset hits the bottom of each
page.

(I am using Access 2003, if that makes any difference)