Access Data Entry Form
 

Hello, This question is been bugging me more almost 2 weeks but can't
come up with a solution. Here is what I want to do.
I have a access data entry form "frmprovider" that is linked to a
table "tbleStorage" where every time I enter a new record in the form,
the record gets saved to the table. When the user opens the database,
the form opens up for the user to enter a record, the user enters the
lastname, Firstname, and BillingTin and right there, I want the
database to let the user know if that record is already in the table,
if it is, I would like it to get to that record so the user could put
some updated info's and save the record. If there is no match, than
the user would just fill in other info's and save it. Also, When the
form opens up, it opens a blank form so you don't see all the existing
record and if you want to see all the existing record, you will need
to go to the "tblestorage". thanks!