Duplicates

[Blair Greene]

I'm under a deadline, trying to see if it's possible to prevent duplicates within a combo box for data entry... Can anyone tell
me if this is possible ?

 

[saintsman]

I don't understand why you would not want any duplicates. Surely the combo box is there to allow specific data to be added.

 

[Blair Greene]

I want to avoid duplicates, especially in
the combo box, the system is used for scanning in bar codes for inventory and I need to try a prevent duplication entries, I
am under a deadline on this one...

 

[Pat Hartman]

To prevent duplicates from being added to a table, create a unique index on the field or make it the table's primary key.

I don't understand the reference to the combobox. If the combobox is being used to select the barcode, the rowsource of the combo should be based on a table that contains a unique list of barcodes.

 

[Blair Greene]

Thanks...
The reason duplicates cant be permitted on that db is because it's used for a cable companies inventory... they scan
in hundreds of items per week via "bar code"
with your help I have reloved this problem
by building a relationship to a table that
had the necessary permissions set...