Fill text box with result of query

[lesp1]

I have a form and want to display a value in a text box that depends on the value selected in a combobox.
This value can be found from a query, using the combobox entry.
Can anyone advise me on how to do this?

Cheers

Les P

 

[BillPower]

This should work if the Query returns 1 record as the Result:
Me!TheControlName = DLookup("[QueryFieldName]", "TheQueryName&quot

Or this is how to set a Criteria if necessary on the Result:
Me!TheControlName = DLookup("[QueryFieldName]", "TheQueryName", "[QueryFieldName] = " & Me!ComboBoxName)

Bill