page breaks

[Patti]

I am working on a report containing a subreport for
multiple records. I know how to get one record per page
but can't figure out how to have multiple records per
page that doesn't split the main and subreports. I
don't know much about VB or macros.

Any help is greatly appreciated.

 

[Bruce]

I have recently completed just such a project, so maybe I
can help, but I will need more information. For one
thing, could you describe briefly what you are trying to
do? I take it that the report describes something, and
the subreport lists things related to that. For instance,
if the report describes a meeting, the subreport describes
attendees. If so, do you have the appropriate one to many
relationship established between the source tables for the
report and subreport? Is the primary key of the report's
source table linked to the foreign key of the subreport's
source table (i.e. is a relationship established)? I
think that more information from you is needed.