drop down list for one column in query to show table values

[smgomez]

I have a query where I want to be able to see the list of possible values for one field, so that I can scroll down the list and select versus typing it in. How do I do that?

 

[Andrzejek]

Use ComboBox, set its Style to 2 - fmStyleDropDownList

Have fun.

---- Andy

 

[dhookom]

IMO, you use forms for all user interaction. You can use a combo box on your form to provide a list of acceptable values.

Duane
Hook'D on Access
MS Access MVP