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
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