Query based on combo box value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is based on a query. The query needs a value from a combo box on my form. How can I get the value from the combo box into my query

This is my query..but it doesn't work..it prompts me for the paramete

SELECT
FROM Histor
WHERE OximeterModel=cboSelectProd.Value
 
You need to reference your form similar to this:

SELECT *
FROM History
WHERE (((History.[OximeterModel])=[Forms]![YourForm]!
[YourCombo]));

If you right-click on the criteria block in your query
QBE, you can use the 'Build' option to help reference the
form.
-----Original Message-----
I have a report that is based on a query. The query needs
Click to expand...
a value from a combo box on my form. How can I get the
value from the combo box into my query.
 
Back
Top