L lalexander Dec 12, 2003 #1 I have a customer form that has custid custname Is there a way to prevent a duplication of the customer name ?
I have a customer form that has custid custname Is there a way to prevent a duplication of the customer name ?
P PC Datasheet Dec 12, 2003 #2 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.
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 Dec 12, 2003 #3 Open the underlying table in design view and set a "No Duplicates" index on the custname field.
