Passing values to a query/report

  • Thread starter Thread starter James Rasmussen
  • Start date Start date
J

James Rasmussen

I have a form that has 3 combo boxes. I need to pass the values of these
boxes to a query that is the source for a report.
How can this be done?
TIA
Jim
 
Refer to the form in the query. How are you wanting them passed, as criteria to limit a
field? If so, set the criteria to

[Forms]![frmMyForm]![cboMyCombobox]

The form has to be open for this to work. If you are opening the form as a "pop-up" in the
Open event of the report, then use the acDialog window mode option to halt the report's
code until you make your selections. Have a button on the form to hide the form when you
are done (Me.Visible = False). Hiding or closing the form will allow the report's code to
continue to run. A hidden form is still open, so you can get the values from it. Remember
to close the form when you close the report.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-through query for sub report 1
pass query parameter value to report 8
Choose a value from a combo box based on a text box 0
sp and query in the same report 4
Problem passing SQL string to Record Source property of a Report 3
Passing values between reports 1
Report show query criteria 3
make value of text box (or other control) that of query 4

Back
Top