Populate Report using Public Functions?? - Need Assistance

[AustinMan]

I have working on Form that uses ComboBoxes for criteria for doing Summary Totals on Professional Type information.

I run SQL statements based on criteria. I also used "ALL" as a selection for Summary Information.

The SQL statements run great.

I finally error-trapped the instance with no records are sent. (Defaulted to ALL)

Can I pass the values of the comboboxes to a report.

Here the catch. I am recreating the query, Print Preview the pre-defined report. And then delete that query.

The Report is static. Once printed or close, returns to Form.

I am using Docmd.Open Report for this process.

Can I pass the values of the criteria, two comboboxes in a public function, for that on-the fly report?

The SQL statement is located in Form. The Query is created in the form, and the statement to open is behind the form.

Please help. Any questions you need, just ask!!

Thanks!