Combo Drop Down List (1 Viewer)

[JKB]

I have a typical employee table, all the usual stuff. With many employees, it results in many, maybe up to 30 possible different cities of address. I would like to create a form, on which there is a drop-down combo that displays an single, individual entry for any possible city that exists for current employees, so I can "search by city". If I have a "City" table, then "all" of the possible cities in that table drop down. Not all are used. I only want the ones to drop-down that are actual possiblities based on the employee table, but only 1 display per city that exists in the employee table.
Hope this is clear.

 

[KevinM]

Base your combo box on the City field in the Employees table and in the query's properties set Unique Values to Yes to avoid showing duplicates.

HTH

 

[rhay]

Where is the setting for the query to set it to Unique values?

Robert

 

[KevinM]

In design view, from th emenu bar select Query, Properties.

HTH