Quizzes & Puzzles48 mins ago
MS Access Unbound Form Assistance
1 Answers
Hi, I've got an unbound form in Access 97 thats pulling data from 4 tables.
When a users ID is entered into the form (Table1) I want the form to display the users name (taken from Table2 - users) to make sure the right ID has been entered.
There is a relationship linking user id in table1 and table2.
I've never had a problem with this using bound forms, and I'll bet there's a simple solution, but I can't figure it out at the moment.
Any help?
BTW, as I was pulling data from 4 tables I've used an unbound form, no combination of a bound form would give me the right control over all the fields.
When a users ID is entered into the form (Table1) I want the form to display the users name (taken from Table2 - users) to make sure the right ID has been entered.
There is a relationship linking user id in table1 and table2.
I've never had a problem with this using bound forms, and I'll bet there's a simple solution, but I can't figure it out at the moment.
Any help?
BTW, as I was pulling data from 4 tables I've used an unbound form, no combination of a bound form would give me the right control over all the fields.
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by tpreece01. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
It is hard to be sure exactly what you are doing but here are two scenarios.
If the ID is being typed into a text box on the main form set the control source for the second box to lookup the name from Table2.
ControlSource = DLookUp("Username", "Table2", "Table2.ID = Forms!FormName.FirstTextboxName")
If you are typing directly into a field in a subform displaying Table1 set the control source of the box like this:
ControlSource = DLookUp("Username", "Table2", "Table2.ID = Forms!MainForm!Subform.FieldName")
If the ID is being typed into a text box on the main form set the control source for the second box to lookup the name from Table2.
ControlSource = DLookUp("Username", "Table2", "Table2.ID = Forms!FormName.FirstTextboxName")
If you are typing directly into a field in a subform displaying Table1 set the control source of the box like this:
ControlSource = DLookUp("Username", "Table2", "Table2.ID = Forms!MainForm!Subform.FieldName")
Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.