Dynamic subreport updating

[GB]

I need to update dynamically the subreport record source (query),
which contains "account number" field in WHERE part of the query,
by the value of "account number" text box from main report.
I need this to update subreport content for each page of the main report.
The text box and the subreport resided in Detail band of the main report.
Please help.

Thanks,
GB

 

[Duane Hookom]

Have you considered using the Link Master/Child properties like you would
use with a form and subform?

 

[Marshall Barton]

I need to update dynamically the subreport record source (query),
which contains "account number" field in WHERE part of the query,
by the value of "account number" text box from main report.
I need this to update subreport content for each page of the main report.
The text box and the subreport resided in Detail band of the main report.

The only way I know of to do that is to use the subreport
control's Link Master/Child properties to sybchronize the
main and subreport to the detail's account number field.