Dynamic subreport updating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GB - 14 Oct 2005 23:20 GMT

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

Reply to this Message

Duane Hookom - 15 Oct 2005 00:51 GMT

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

Signature

Duane Hookom
MS Access MVP

>I need to update dynamically the subreport record source (query),
> which contains "account number" field in WHERE part of the query,
[quoted text clipped - 5 lines]
> Thanks,
> GB

Reply to this Message

Marshall Barton - 15 Oct 2005 01:09 GMT

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

Signature

Marsh
MVP [MS Access]

Reply to this Message