Parameter querry with dropdown????

  • Thread starter Thread starter Bill Lambry
  • Start date Start date
B

Bill Lambry

Is it possible to create a parameter query that utilizes a
drop down for selection of parameter.

Similar to using a lookup in a table? And if this is
possible how would one implement this, VBA?

TIA
 
You need to use a form with a combo box for that. In the query, refer to the
combo box like so ...

SELECT * FROM SomeTable WHERE SomeField = Forms!SomeForm!SomeCombo

The form must, of course, be open when the query runs.
 
Back
Top