dynamically change sub-report "recordsource" for each page of a report

[Guest]

i am developing a report that is based on one table - each record begins on a new page (70 records or so) which works well

each one of those records has table containing data related to it

i want to be able to include a subreport on my report that, as each record begins on a new page, the recordsource for the subreport changes

i want to achieve the effect that, on each new page, the subreport's recordsource is changes based on the "parent" record, and that subreport shows the correct data

any thoughts? i really need help on this one!!!!!!

 

[Marshall Barton]

i am developing a report that is based on one table - each record begins on a new page (70 records or so) which works well.

each one of those records has table containing data related to it.

i want to be able to include a subreport on my report that, as each record begins on a new page, the recordsource for the subreport changes.

i want to achieve the effect that, on each new page, the subreport's recordsource is changes based on the "parent" record, and that subreport shows the correct data.

any thoughts? i really need help on this one!!!!!!

Can not be done! Once a subreport starts, its record source
can not be changed.

It's a rare situation where each main report racord is
related to a different table. If you don't have a good
reason for this, you should rectify your table structure.

If you do have a good reason (within the rules of
normalization), then you could either use multiple
subreports (making them visble or not as needed) or use one
subreport based on a query that combines the data from all
the tables (the Link Master/Child properties can be used to
select the appropriate records).