entering new records in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top