Trap Duplicate Entries On First Field
Posted on 2008-10-01
There is a table in my database that contains information on clients (tblClients). Two fields in the table - ClientName and ClientID - are indexed, no dups allowed. The client name is the first field in the form and I would like to trap it if it is a duplicate of an exisiting name, before any more fields are entered. I've tried a macro for On Lost Focus, On Dirty, etc., but nothing has worked. Please advise!