Dynamic subreport updating

  • Thread starter Thread starter GB
  • Start date Start date
G

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
 
Have you considered using the Link Master/Child properties like you would
use with a form and subform?
 
GB said:
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.
Click to expand...


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.
 
Back
Top