warning on duplicate

[hmho]

I have form where the field [ProdNumber] is unique and no duplicate. How can I have warning that will tell who is entering the data when they try to enter duplicate record.

Thanks

 

[Galaxiom]

Make the field in the table Indexed (No Duplicates). Access will complain automatically when a duplicate is entered.

 

[sakthivels]

Hi,

Indexing the field with no duplicates is a good idea. But I would rather personally suggest, auto generate the ID. You can use the Autonumber field or you can setup your own ID generating routine. Try searching for Serial generating routines in the forum.

Regards,
Sakthivel