Criteria pop up to provide list instead of input field

[SteveBB]

Hi Guys,

Hoping someone can help with this.

I'm familiar with using [] enter query criteria when running but I'm looking to take this a step further.

I have a field in my table which is based on a drop down and contains perhaps 12-15 options.

I'd really like the pop up to display a list to select from rather than a manual entry box.

Anyone know if/how this can be achieved?

Thanks in advance

 

[Micron]

I have a field in my table which is based on a drop down

Not sure what you're saying. You have a lookup field in a table but want a listbox instead? Not possible AFAIK.
Really, a combo box is based on a data source (query or table). Table fields are not 'based' on anything (except maybe for lookup fields, but I wouldn't describe the field that way). Nor do know what is meant by a manual entry box. Hence my confusion.
If you're saying you have a form with a combo with 12-15 choices, how is it so difficult to choose from such a short list that you'd want a popup form with a listbox instead?