Help with adding items to a combo box

[bronze2k]

Hi

What I want to do is check that a value is not in a Combobox list before
adding it so that I do not have any duplicates entries.

Can someone please help

Thanks

 

[DanClaxton]

Your problem could easily be resolved in the data table design. In design
view for the table just select the field that you do not want duplicates in
and set the Allow Duplicates to a "No". That will save you from doing any
coding.