Duplicate Field Message

hkimpact

Registered User.
Local time
Today, 12:38
Joined
Apr 27, 2012
Messages
51
I currently have a field on a form thats indexed (no duplicate values). What I want, is if the user types a existing social in the field, that it lets them know the social is in use and that the record will not save.

I believe this will have to use the before update event for my pSocialSecurity control and that I will need to use the DCount function.

Any help would be appreciated.

Thank you ahead of time,
Rick Armstrong
 
Add the validation rule to the field, what type of field are you using and what is the datatype?
 
Thanks for the quick reply.

I am using a textbox which is using a Text DataType.
 
The link doesn't seem to work correctly for me. Not sure if its my work blocking the site or not.

I opened it up on my smartphone (what would we do without them haha). I'll give it a run and let you know if it works the way I want.

Thank you!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom