I have created a two table, one to many relationship, database. The main
table is the ssn and persons personal informaton, phone address, city etc. I
have created this db to copy information from a job application. The purpose
is to track the progress of the applicant through the hiring process. This
main table is the only table that might be updated later if the person
applies for a different job later.

Their ssn is the primary key on this table. The other table is a subform  
and its unique ID is an auto assigned number that is unique to the job
application rather than to the persons name.

What I want to be able to do is to make certain that if the same person
comes in later that the info in the ssn table is still correct. As it is now,
the user has to complete the form, which includes the info from both tables,
and attempt to enter it before it is known if the ssn has already been
stored. Is there any way of using a command button to run the persons ssn
BEFORE completing the rest of the form to see if they are already in the
database? Or, how could this be accomplished.

Thanks for any help you can give....