Prevent Combobox duplicates

[SeanK]

I know how to search both a listbox and a combo box for duplicate entries and remove them.

What I would like to do is prevent a duplicate from ever getting entered in the first place.

How would I do that?

[Keithuk]

MartinLiss has answered this, do a search for duplicates listbox

http://www.vbforums.com/showthread.php?t=354651&

[SeanK]

I did...I couldn't find anything.

Maybe I just wasn't using the right search criteria.

I'll try again.

[Harsh Gupta]

I know how to search both a listbox and a combo box for duplicate entries and remove them.

What I would like to do is prevent a duplicate from ever getting entered in the first place.

How would I do that?

could you provide some more information. from where are these values coming?

BTW, while entering a value in the box, check it in the list of values in the listbox or combobox.

[Hack]

Is the combo initially being loaded from a database table but your customers can add entries and you want to check to make sure they none of them already exist?

[SeanK]

Is the combo initially being loaded from a database table but your customers can add entries and you want to check to make sure they none of them already exist?

Yes, exactly.