Validation rule for no duplicate value 1

[edge70]

I cannot find how to write a validation rule in my form to pop a message when the user tries to create a duplicate entry, my field is indexed with NO duplicates so at this moment access pops an error message for the duplicate entry only when I have finished to fill ALL fields of my form.

Can someone help me to find a way to pop my warning message as soon as the field as being filled ??

Thanks!

 

[PHV]

Take a look at the DLookUp function you can use in the AfterUpdate event procedure of the control.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244