SubReport Question

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I have a report which details a customers payments for the year. This report
has a sub-report that is a chart of those payments summarized by month. The
sub-report uses a separate recordset than the report.

How do I get the sub report to refresh on a customer break. I have
captured the customer break and I am successfully building the sub report
recordset. But I can not get the sub report to requery and refresh.

Can I do this?

CL
 
Charles,
The standard Access way of doing this is to have the query for the main
report and the query for the subreport to have a common field. Something
like CustomerID. Then, in the properties of the subreport control you'd set
"LinkChildFields" and "LinkMasterFields" both to be CustomerID.

hth,
David Straker
 
Back
Top