How to create a query field dependent on a form field?

[lccrews]

I'd like to know if there is a way to make a field in a query dependent on a value from a text field on a form. Namely, I'd like to take a field from a table and multiply it by a value from a field on a form.


I tried "Input(mg): [Percent]*[forms]![frm_Formulation]![Text4]" but the field is blank when I run the query.
When I remove "[forms]![frm_Formulation]![Text4]" my percent field shows up as it should.

Cross posted from https://stackoverflow.com/questions/...n-a-form-field

[June7]

And you don't get a popup prompt to enter Text4 value? Sorry, since syntax is correct and assuming textbox has value, can't explain why this fails. However, why reference a form textbox? Is this value not saved to a table? What do you want to do with the query? Is it RecordSource for a report?

If you want to provide db for analysis, follow instructions at bottom of my post.