How to set the value of textbox in vba access form to query field value

Question

The form I am working on

How do I set the value of the textbox status to the field value of a query. After the selecting the value of the comboxbox, the textbox should show a field value of the query based on the selected product_code from the combobox. combo box uses another table to but product-code is the same in both data sources

Answer 1

Use DLookup:

=DLookup("[FieldName]","[QueryName]","[ProductCode] = " & [cboProductCode] & "")

If the code is text:

=DLookup("[FieldName]","[QueryName]","[ProductCode] = '" & [cboProductCode] & "'")