entering new records in access

[Guest]

I am trying to develop a database that tracks records with SSNs. I have an
old database that allows a user to enter the ssn into a text field and it
pulls the history of that individual up. However, if it is a new SSN, then a
new entry is automatically created and there is not need to click the "arrow
asterick" button to create a new entry. Basically, I do not want one of the
users to overwrite an older record everytime they enter a ssn into the field.
How do I enable this capability?

 

[Pat Hartman]

You need to use an unbound text field as the search field. Your code needs
to automatically go to a new record and populate the hidden bound SSN field
when the SSN entered in the search field isn't found.