Multiple Values in Combobox (1 Viewer)

[Irie]

I have a combobox which has multiple values repeated, how can I limit the list to show only one value, and no duplicates??
Thnx for any suggestions,

 

[princess15s]

is the combo box feild a primary key? If it's not create a table just for that combo box and enter the values you want in the table. then you could use this table to select data to save in other tables.

 

[Rich]

Base the combo on a query and select unique values.