How to link 3 different combo boxex in a form (as report criteria) to the report

[Hart]

I would like to use 3 combo boxes in a form as parameter
criteria for a report.
When I open a report, there will be a pop up form with 3
combo boxes. I am already able to link the report to the
form. However after the user select the content of all 3
combo boxes and then click the preview report command
button, I would like to be able to open the report based
on the selected option from the 3 combo boxes. Currently
after clicking the preview command button in the form with
combo box, the report can be opened but it shows all the
data, not the specific data based on the criteria selected
from the combo box in the form.
Thus, how to link 3 different combo boxex in a form (as
report criteria) to the report?
Can anyone help me with this please? I will really
appreciate your response in this.

Thanks,
Hart

[Wayne Morgan]

ps. To refer to a value on the form, the form must be open. I assume you are opening the
form from the report with the "acDialog" window mode argument since this will halt the
code and the opening of the report until you are done with the form. The code will
continue when the form is closed or hidden, in this case you need hidden (Visible=No)
because the form has to be open to read the combo boxes.

--
Wayne Morgan
Microsoft Access MVP