Allow Doubles

[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

 

[Guest]

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.