SubReport Question

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
 
D

David Straker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing a sub-report 0
VBA to look for more than 1 key word and highlights 8
Prompt For Replace in Selection And More... 0
Reports and SubReports Spacing 6
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
report with multiple subreport question 6
Reference subreport control if HasData 3
Linking subreport to report 4

Top