How to pass filter condition to SubForm in Report

[Rick]

Hi,
I have a report, it's contains some subform(data sheet and Graph).I can pass filter to report, but I can't pass filter to report's subform. Report and subform's datasource come from two query.How to pass filter condition to SubForm in Report.

Thanks
Rick

[brju]

If you mean by filter a subset of the data, based on specific criteria - one way would be to create a form which the user fills in with the required criteria (with a command button on the form to run the report) and refer to this form when running both queries, for example, in the applicable criteria row in each query type in: Between [Forms]![frmInputDateForReport]![txtStartDate] And [Forms]![frmInputDateForReport]![txtEndDate].

Obviously you would have to substitue the from / control names used here with your form / control names.