duplicate check

[rosito]

Hi all,
I make a table "CATGRY" with 3 col: CATGRName, CATGRPic, CATGRDescrip
For field CATGRName i set "Indexed =Yes(No Duplicate)" in the table.
Then make form, based on this table.... When I input duplicate CATGRName I want receive my msg "DUBL DUBL", clear box and input new name again.
What i need to do in my form, plsss?

 

[MStef]

Look at "DemoDUBLa2000.mdb"
Open form and try.

 

[coyote]

Dublicates

Hi Rosito use the following link .

http://www.databasedev.co.uk/duplicates.html

hope you get the answer

Cheers