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.

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

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

Robert

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

HTH