Can’t keep together a record.

[myhnews]

I have a report that has 5 sub reports. Each sub report can have its own sub sub reports.

The size of the sub sub report will never be more then 2 inches in height.
The sub report and its sub sub reports always have to stay together. If not, start a new page.

I can’t set the main report to Keep together = YES because this can cause a lot of extra spaces between each sub reports.

So I set the main to Keep together = No

My problem is that even each sub report is set to Keep together = YES it will not stay together because the main report Keep together is set to = YES

For me it makes no sense of how access works. If I have a group set to keep together = yes, it should keep this group together. It should overwrite the parents’ group settings.

Can anyone please share their experience with this problem?

Thanks
Abe