dropdowns and the criteria field

[yobevas]

is it possible when I am in design view, to create a criteria that allows for a drop down selection when the question is asked in the query? for example, if I have a Code table
Code table;
purchase Code
2201-01-22-02
2201-02-22-02
2201-11-22-07
2201-12-22-07
2201-21-22-01
2201-22-22-01
When I create my query, I put in the criteria field (in design view) [which purchase code?]

My end goal is when I open the query it will ask me for the purchase code, and I want a drop down to choose from. Is that possible? Wow reading that I sound mixed up, but that is the best explanation I can give.

 

[pbaldy]

In a word, no. To get a dropdown, you need to use a form with a combo box and have the query get the criteria from there.