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
FROM myTable

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?

Thanks,
Maha

Try changing your SQL statement to this...

SELECT myTable.Field1, Forms!myForm!txtTransportCost.text AS TransportCost
FROM myTable;

That should do it.

Kenny Alligood

Hi Friend,

Thanks for you reply. I managed to find the solution.

Many thanks again.
Maha:)