Repeated value in combo box

[ohio]

I have created a combo box which the values retrieved from one of the field in my query. In the combo box, how can i make the value to one each instead of repeating. There are more than one record under the particular values(field)in my query therefore it will repeat in the list. But i want to make it one each. Pls help.

 

[R. Hicks]

In the design view of the combobox, in the Row Source property, change the SQL recordset from:
SELECT.........ect
to
SELECT DISTINCT........ect

HTH
RDH

 

[ohio]

Thanks. It is working.