subreport update problem

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

GB

Hello:
I have a main report (parent report) and subreport
on it. The main report contains text box for account number and record
source for this report returns the number of records equal of number of
different account numbers so the report produce one page for each account
number.
The subreport contains multiple records (account transactions) for the
account from main report.
In general I want a report which contains account number on main report and
account characteriscs on subreport.
Each page of the report contains new account on main report and new account
transactions on subreport.
My problem is: how to pass (update) new account number to subreport when
main report update account number
for new page?

Thanks,
GB
 
You can use the Link Child Fields and Link Master Fields properties of the
subreport (Data tab). For example, if your textbox for account number on
the main report is named txtAccountNum and your subreport has a data field
(from a table or query) of [AccountNum], you would set the Link Master
Fields property to "txtAccountNum" (without quotes) and the Link Child
Fields property to "[AccountNum]" (without quotes). As the main report
changes account numbers, the subreport will be filtered accordingly.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hello:
I have a main report (parent report) and subreport
on it. The main report contains text box for account number and record
source for this report returns the number of records equal of number of
different account numbers so the report produce one page for each account
number.
The subreport contains multiple records (account transactions) for the
account from main report.
In general I want a report which contains account number on main report and
account characteriscs on subreport.
Each page of the report contains new account on main report and new account
transactions on subreport.
My problem is: how to pass (update) new account number to subreport when
main report update account number
for new page?

Thanks,
GB
 
My problem is slightly different:
I need to update dynamically the subreport record source (query) which
contains account number in WHERE part of the query by the value of account
number text box from main report.
Please help.

Thanks,
GB
 
Back
Top