I have written a query that works, it's output is a contact name. I am trying to have two combo boxes define the contact name.
combo 1 branch_name
combo 2 branch_city
text box branch_contact
The user makes a selection in each combo box so the contact name will then appear in the text field. But it seems you can't link a text field to a query. How do you get around this? apprently you can use DLOOKUP or DCOUNT, but i can't seem to relate what is in the help field to my problem.
So in other words how do i update the text field from the selection made in the combo boxes?
Any help would be much appreicated.
combo 1 branch_name
combo 2 branch_city
text box branch_contact
The user makes a selection in each combo box so the contact name will then appear in the text field. But it seems you can't link a text field to a query. How do you get around this? apprently you can use DLOOKUP or DCOUNT, but i can't seem to relate what is in the help field to my problem.
So in other words how do i update the text field from the selection made in the combo boxes?
Any help would be much appreicated.
