Add a keep together property to subreports

[Guest]

I am trying to create a report in Access. The report contains 8 subreports. I
would like to be able to ask Access to keep a Subreport together on one page
when printing, insted of printing the title of the subreport and one record
on the first page and the rest of the records for that subreport on the next
page.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d5ad4a3ca3&dg=microsoft.public.access.reports

 

[Marshall Barton]

I am trying to create a report in Access. The report contains 8 subreports. I
would like to be able to ask Access to keep a Subreport together on one page
when printing, insted of printing the title of the subreport and one record
on the first page and the rest of the records for that subreport on the next
page.

That is a problem and, AFAIK, there is only one workaround.

Place each subreport in its own section. The trick is to
use Sorting and Grouping to create groups with header and
footer sections. If the subreport's were in the detail
section, then use the record source primary key as the
grouping field. If they were in the report or some group
header or footer section, then group on any constant
expression such as ="Dummy" or =1.