Passing parameter to a report

[tredeker]

All,
I've created 2 forms: 1st form lets user select filter criteria and 2nd form appears with record details using the OpenArgs to set the SQL where clause.

I want to do the same, only show a report rather than a form. The catch is that forms don't have the OpenArgs property. How do I pass the selection criteria to a report?

Thanks,
TR

 

[tredeker]

sorry...the second paragraph should read "...reports do not have the OpenArgs property". I'm currently using the OpenArgs property in the form_open section.

 

[RottPaws]

Keep the SQL for the report query as a string in the cmdOpenReport_Click event.

Build the Where clause the same way you do for the form and then append it to the SQL:
strReportSQL=strReportSQL & strWhereClause

then open the report and then recordsource to the SQL string and then make the report visible.
Rott Paws

 

[tredeker]

works like a charm --- thanks!