I have a query that has 3 fields and gets the values I want. What I am looking for is how to get one of those values into a field on my form after I make a selection from a combo box. The query uses another query to get its results.
The examples I'm seeing of this is to filter a combo box from the value of another. I am not looking for that. I am looking for a box to be the criteria for a query based on another query. These are physical queries under the query tab. Then I need a text field on the same form to show the value of the third column of the query and not the combo box. It's getting the value from the query that I'm having trouble with.