ChampionDuy
Registered User.
- Local time
- Today, 00:13
- Joined
- Mar 14, 2002
- Messages
- 94
I have attached a Zip File that holds 3 tables and my form which will appear on Startup. I have a field in the form that is where a user enters in a SSN. Here is the problem that I am having.
When a user enters a SSN that is already in the Database my message appears alerting the user that the SSN already exists. The problem comes after that. The very first time the user attempts to leave the SSN text box ACCESS will also show a message after mine that says.
"The Value in the field or record violates the validation rule for the record or field"
This message only appears the first time a user tries to leave the field.
How can I get rid of this message. I set the waarnings to off but that does not seem to work and I tried using the error handler but it does not work either.
Please take a look at my form and let me know what you think.
Thank you very much.
When a user enters a SSN that is already in the Database my message appears alerting the user that the SSN already exists. The problem comes after that. The very first time the user attempts to leave the SSN text box ACCESS will also show a message after mine that says.
"The Value in the field or record violates the validation rule for the record or field"
This message only appears the first time a user tries to leave the field.
How can I get rid of this message. I set the waarnings to off but that does not seem to work and I tried using the error handler but it does not work either.
Please take a look at my form and let me know what you think.
Thank you very much.
