Subreport CanGrow Formatting error
Posted on 2003-12-01
OK, here is the problem.
I have a Master report, with 8 unbound subreports All with the CanGrow = true, when On Open the Master report binds the subreports based on selections from a form. This all works great.
Except 1 of the subs takes multiple pages and the subreport after it gets interspersed at the bottom of the pages of the previous sub instead of comming after it.
Other information that might help.
-None of the subreports overlap
-I can fix the formatting problem by reversing those two subreports, but the person requesting the report can't have it out of order.
-I have messed with the bring to Front, to change the order in which Access formats the subreports, and the error does not change
-All Subreports are highly dynamic (All controls are unbound until formatting)
-All subreports are copies of 1 subreport, so they all have the same control names, and code, but different control sources.
Thank you in advance.