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?

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

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

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

Thanks that helped me figure it out!

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

Thanks,
Ian

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.