Is it Possible to Filter Report from Two Different Forms!

[cap.zadi]

Hi,



I am using a FormYear which will filter the report results "ReportA" for year via Combo Box CboYear with a criteria given to QryReportA "[Forms]![FormYear]![CboYear]". Can i use the same query and report to filter the results from "FormB" by another Combo box CboMonth on this form.

Note: The Year and month both fields are available in Query and Report.

[June7]

Yes, report can be filtered with input from 2 forms, but why not have 1 form?

[cap.zadi]

Well, Yeah you are right. I never thing about it. how silly, i am. I can put two sub-continuous forms at one main form to be filtered with relevant combo boxes and then can put criteria with OR/Is Null to get filtered report.

[cap.zadi]

Its working fantastic. Thanks for usual support.