Duplicated value

  • Thread starter Thread starter Chai
  • Start date Start date
C

Chai

How can we protect a user not to enter a duplicate
fielname? For example: I created a form called Product
Category which has CategoryID and CategoryName.

My goal is to protect a user not to enter the same
CatergoryName.

Is there anybody know how to write this code. Please help.

Best regards,
Chai
 
If CategoryName is a field defined in a table you can make the field unique
in the table design. This will then not allow duplicates to be entered.
 
Back
Top