Parameter Query with drop down list

[JonathanT]

Is it possible to have a drop dowm list show in a parameter or any other type of query? I do not want to select a value from a combo or text box on a form. When the query runs I want a drop down list to appear so I can select the value to use. Is this possible?

[madpiet]

Is it possible to have a drop dowm list show in a parameter or any other type of query? I do not want to select a value from a combo or text box on a form. When the query runs I want a drop down list to appear so I can select the value to use. Is this possible?

Nope. Parameter queries at best give you a text prompt, so no combobox option. You'd have to use an unbound form.

[Gicu]

Not using native Access functionality as madpiet mentioned above, but you could write a custom VBA function that would open a small dialog type form (modal) with the combo of your choice...

Cheers,

[Welshgasman]

O/P said they did not want to use a form, but do it in a difficult way?