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