Allow Doubles

  • Thread starter Thread starter Hector Sanchez
  • Start date Start date
H

Hector Sanchez

Can somebody please help me with question? If I allow
duplicate data to be entered into my table field [Client]
because it is neccessary how could I then detect this
situation every time it occurs and tell user on my form?
I would do this so they save time looking up information
twice. The duplicate is neccessary because there is still
difference in records.

Thank you all,
Hector
 
I haven't tried this, but it might work for you. As soon
as user finishes keying Client on form, you can have code
to perform DLookup function to see if a record for that
client already exists.
 
Back
Top