Managing group data and sub report page breaks

[GPSPOW]

Hi,

I have a main report that lists data grouped by physician:banghead: for totals of the procedures they have performed within a given time frame.

At the end of the group I have placed a subreport that gives summary data related to the physician with its own headers.

I am having a problem when the page has one line left, the header section of the sub-report prints and the data associated with the sub-report is printed on the next page with no header.

Is there a way to tell Access to force a page break if there is less than 2 lines remaining on the page so the headers stay with the data in the sub-report?

Thanks

GPSPOW

 

[vbaInet]

I believe it's possible but because it's been a long while since I touched Access I can't remember if doing it will mess up with your page numbering. I think it actually does.

Why not set the Repeat Section of the group's Header (that contains the labels) to Yes? That will it will print on each new page.