I have the TempVars under a textbox from a from. I am entering the date on the form and I want to pull this date in a query so I can process some calculation.
I follow your instructions and I create a new query to I can see the value by itself and I does not return anything
I don't know what having the TempVars under a textbox from a from means. Please show us the code that is assigning the textbox value to the TempVar.
But if the form is open when you run the query I wouldn't use a TempVar but instead a reference to the textbox directly in the calculation. Let's say you wanted to add the field named Tax to the amount in the textbox named txtAmount in a form named frmMain then the expression would be
A date won't show up in a query expression without first being converted to a string. You can see in the attached database that it shows up when you use CStr like:
Code:
SELECT Table1.ID, Table1.F1, CStr([TempVars]![RecDates]) AS Exp
FROM Table1;