Subforms, changing record source and page breaks

[blair.christopher]

I'm trying to create a report that brings in data from 5 different
tables. Each table has multiple lines of information for different
people. I'd like to lay out 5 subforms on a report page, each with
records from the same perosn, then force a page break, and display the
5 subforms again with records from the next person. Is it possible to
do this? I just don't see any way to change the record source of the
subforms in midstream like that. Thanks for your help.

 

[Marshall Barton]

I'm trying to create a report that brings in data from 5 different
tables. Each table has multiple lines of information for different
people. I'd like to lay out 5 subforms on a report page, each with
records from the same perosn, then force a page break, and display the
5 subforms again with records from the next person. Is it possible to
do this? I just don't see any way to change the record source of the
subforms in midstream like that. Thanks for your help.

You can not change the record source for each detail. Use
the Link Master/Child Fields properties to link the main
report data to the subreports.