Subform Header seperating from details

I have a subform on a report and depending on the amount of data on the main form, the subform header is sometimes fitting on the first page but bumping the details of the subform on the 2nd page.  

Is there a property that I could set on the subform to ensure that the form header stays on the same page as the subform details?  
gcgcitAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
<<Is there a property that I could set on the subform to ensure that the form header stays on the same page as the subform details?   >>

  No.  Only thing you can do is in the OnFormat event see how far down the page you are.  If too far, then make a page break visible.

  Or through the Group header properties, you could just automatically do a page break before the header prints.

JimD.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Could you use a Report for this?

Reports are made for printing and you have much more control over the output...
0
 
gcgcitAuthor Commented:
Sorry it is on a report... I meant to type subreport above.
0
 
gcgcitAuthor Commented:
I have a report with multiple subreports.
0
 
gcgcitAuthor Commented:
Put pagebreak above that subreport.
0
All Courses

From novice to tech pro — start learning today.