Combobox

  • Thread starter Thread starter Chris
  • Start date Start date
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?
 
Hi Chris

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

Select DISTINCT City from Customers;
 
Back
Top