title: How to create a query field dependent on a form field?
body: <p>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.</p>
  
  <p>I tried <code>Input(mg): [Percent]*[forms]![frm_Formulation]![Text4]</code> but the field is blank when I run the query. </p>
  
  <p>When I remove <code>[forms]![frm_Formulation]![Text4]</code> my percent field shows up as it should.</p>
  
  <p>Cross post <a href="http://www.accessforums.net/showthread.php?t=68017" rel="nofollow noreferrer">http://www.accessforums.net/showthread.php?t=68017</a></p>
  
  <p>Suggested Edit: Here is my SQL: <code>SELECT Tbl_Formulas.Item, Tbl_Formulas.RawMaterial, [Percent]*1257 AS [Input(mg)], Tbl_Formulas.[Quantity(kg)], Qry_Percentages.Percent
  FROM Qry_Percentages INNER JOIN Tbl_Formulas ON (Qry_Percentages.Item = Tbl_Formulas.Item) AND (Qry_Percentages.[Quantity(kg)] = Tbl_Formulas.[Quantity(kg)])
  WHERE (((Tbl_Formulas.Item)="a475ad"));
  </code></p>
  
  <p>I tried to recreate this instance in a new database and could not. The function works. It just doesn't work in this db...</p>