Pass WHERE clause to Sub-Report

Q

QB

I have a main report with a unbound sub-report. How can I pass the WHERE
clause used to filter the Main report to this sub-report?

Thank you,

QB
 
D

Duane Hookom

I either add some criteria in the subreport's record source query or change
the SQL property of the subreport's saved query record source.
 

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

sub-report based on same criteria as main report 2
Filtering subreports on main report 0
Pass-through query for sub report 1
Sum of sub-form/sub-report 10
Variable Sub-report 2
Sub - Report inheriting the Where clause 2
How to programatically add an existing report to a report (as sub) 1
Pass parameter value to sub report query 3

Top