query display value from calculated, unbound textbox

[natep26]

Here's the situation.

I have a calculated value in an unbound textbox (avghcppmw). I want to run a query (qinsphistory) in which one of the fields is the value of the textbox (avghcppmw).

Is there any way to pull the value from the form and display it in the query. I'm assuming not.

I also assume the only way to do this would be to create a query that would calculate the textbox value and base (qinsphistory) on the newly made query.

Is this correct?

 

[ajetrumpet]

I have a calculated value in an unbound textbox (avghcppmw). I want to run a query (qinsphistory) in which one of the fields is the value of the textbox (avghcppmw).

You can't do this because the query's unit of measure is a RECORD. The only thing you can do with it is use it for criteria. The value ALONE of the textbox is unassociated with the records of your query.

I also assume the only way to do this would be to create a query that would calculate the textbox value and base (qinsphistory) on the newly made query.

I think you're more on the right track here. The value of the txtbx was calculated somehow, so the values that were used for that calculation have to be in a table somewhere...

 

[natep26]

The problem with your solution is I don't have a field or a table. The textbox is unbound. The values calculated in the avghcppmw textbox don't actually exist anywhere.