Bound Text Box for SSN check for duplicate first

[kellan4459]

I have a text box that the user will enter the SSN in. I need to figure out a way that when they tab to the next field access will check to see if SSN has been entered before. If it has I want a vbok error message to show that the SSN has been entered before. On ok the field will be cleared. What is the easiest way to do this?

 

[jwindon]

Is the bound field a Primary Key in the underlying table?

 

[kellan4459]

Yes the bound field is the primary field in the table.

 

[jwindon]

Kellan, Follow this thread.....for your answer.
http://www.access-programmers.co.uk/ubb/Forum2/HTML/001190.html

 

[kellan4459]

Thanks that helped me figure it out!

 

[ianacole]

Can the code in the earlier thread be modified to compare text and error duplicates?

Thanks,
Ian

 

[kellan4459]

If you are trying to check a text box against a primary key or field in a database then yes it can be modified to fit your needs. I had to modify it slightly to fit my needs and it worked all except one line. I removed that line and no further problems.