SSN Lookup

[Rosco]

I am creating a database for work that tracks when a persons state
certification expires. I currently enter all data through a form, but
when I am keying in a certification that happens to be a renewal, of
course I get the duplicate error message. Is there a way that as soon
as I enter the social, the form checks the table, if the social exist
it would display that information so i can update the date, and if it
doesnt exist, create a new entry?

 

[ruralguy via AccessMonster.com]

Put a ComboBox on your form that "Looks up a record" in your RecordSet. It
will be unbound and have code in the AfterUpdate event that can be modified
slightly to do what you want. You will leave your current SSN control alone
other than locking it and fill it in from the ComboBox AfterUpdate event.