Parameter querry with dropdown????

[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

 

[Brendan Reynolds]

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.