Combobox

[Chris]

I am using a combo box on a form to enter text data.
Currently, the row source for the combo_box is the same as
the field it is bound to. How can I filter this so, if the
information appears multiple times, it will only appear
one time in the combobox list?

 

[Graham Mandeno]

Hi Chris

Insert the keyword "distinct" in the Rowsource SQL statement. For example:

Select DISTINCT City from Customers;