Text box based on a query

[DFowler]

Hopefully this is something quick and easy i currently have a form which is using a particular query to populate the fields etc. I have one field that i need to be based on a seperate query altogether, i have tried almagamating the queries but this does not work, Is there some code that will pick up the results of the seperate query to populate an empty unbound text box on my form.

 

[DFowler]

Ok now to the answer, The query should just be returning one field based on certain criteria from a combo box on the form, so for instance if the user selects Plant type the query returns a letter which correlates to something else further on in the process, Strangly this aspect works its just the link between the orig combo box and the query returning the letter which should be shown on the form