Creating a Form that will auto lookup?

[moleary]

I was wondering how I could make a form to where if I enter a social security number for a client it will look it up and tell me wether or not that is that client? or Rather who that social security belongs to and if I could get it to ask me if that is the correct person or not?

 

[andy101]

Create a Text Box to allow the user to enter the number, Create a macro button and use the wizard option to open the client form.
Select the open specific data option and then select your text box and the client number on the client details form, access will then open the client details for the number you enter.

 

[llkhoutx]

Use the social as the bound column in combox box and link to a form with the the social and name in textboxes.
This will tell you that you have a valid social and the name. If the social in not in the list, it will tell you so - then you don't have a valid social.