I'm having a main report with 5 subreports. Subreports can grow and shrink. If a subreport starts at the bottom of the page I want the subreport to start at a new page so not half of the subreport is on one page and the rest on the second page. I tried all different combinations of keep together in the main report and the subreports but I can't get it to work. OS: win2k, Access 2000. Any help would be much appreciated.
Go to the Sorting and Grouping window and create 5 -vitrual- groups in the "Field/Expression" column (you don't nead fields in order to create the groups, just write a name). Then give them keep together permitions.
Put each sub report in each group either in the header or the footer.