duplication of the customer name ?

L

lalexander

I have a customer form that has

custid
custname

Is there a way to prevent a duplication of the customer name ?
 
P

PC Datasheet

Go back to the table the form is based on. For the CustName field, set the index
to Yes, No Duplicates. An error message will popup if a duplicate name is
entered. Trap that error with your own message.
 
J

John Nurick

Open the underlying table in design view and set a "No Duplicates" index
on the custname field.
 
Top