Pull Data From Table

[hmongie]

Hi, hope someone can help.

I have a only one table. Fields are: FirstName, LastName, SSN, Address, City, State, Zip, ID_Type (combo box), ID_Number, Race(combo box), Gender(combo box), and Purchase_Amount.

I don't know how to do this. I need this to occur, when the user begins a new form, as they start to input in the SSN, all of the other fields will be populated with records if the SSN matches something that exist already. Although, the user can simply override or change all of the fields as neccessary.

One execption, the Purchase_Amount field will not change at all. The user will have to make the input manually.

Any idea please let me know? Thanks.

 

[KeithG]

use the textbox for the SSN numbers after update event to filter the form

 

[hmongie]

I'm not too sure what you are saying. Can you help clarify?