Adding Command Button to Form for Query

[Guest]

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

 

[Guest]

Security for ssn, address, dob, etc is good advise. Encryption and password
protection should be ok if you are on a secure network.

Us the macro button wizzard and try many of them out. Look at the Visual
Basic Code behind the wizzards. Try to understand the error traps and Dim
statement.

 

[Guest]

I would strongly advise you against creating any database that stores social
security numbers! You are opening yourself up to lawsuts if this information
is ever hacked into. Access is not a very secure database. As a minimum, you
should store the ssn information in an encrypted form.

Dorian