Combobox

C

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?
 
G

Graham Mandeno

Hi Chris

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

Select DISTINCT City from Customers;
 
Top