I created a NEW form. It has an unbound Text box #1 to be used for entry Social Security Number). It also has a text box # 2 for the results of the query (Name).
I create the query and in the criteria I reference Text box # 1.
I put a value inthe form (SSN). I check the query and it has used the value from text box # 1. BUT I cannot seem to get the results of the query (Name) back to the form in text box # 2?? Text Box # 2 on the form references the name field in the database.
Please explain what I am doing wrong?? And how do I do it correctly….
Thanks for your help!