Access 97 Question - TechRepublic
General discussion
August 20, 2001 at 01:07 AM
mra2

Access 97 Question

by mra2 . Updated 24 years, 10 months ago

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!

This discussion is locked

All Comments