Extract Field Value
I have a form with a text box. I want to be able to extract the value in the that field within a query. For example, my form name MyForm, the text field name txtTransportCost.
My Query statement:
SELECT myTable.Field1, Forms!MyForm!txtTransportCost AS TransportCost
However, this query only displays the contents of Field1 and TransportCost is Null.
I wish to extract that value in the text box in MyForm. How to do that?