Multiply values

[livvie]

I am trying to multiplytwo values it works fine sometings but not others.Here is the code
MyMatCost = (Forms!frmEstimateComplete.Form!fsubEstDets.Form!fsubMatsEst.Form.txtSubtotal * Forms!frmEstimateComplete.Form!fsubEstDets.Form!fsubOpsEst.Form.Parent!txtQuantity.value)

 

[Rich]

Why is quantity stored in another table?

and where is this code running from?

 

[livvie]

Why is quantity stored in another table?

and where is this code running from?

The problem wasn't with the code the values were being emptied by a requery in the wrong place.
To answer your questions - the qty is held in a header record with the prices in a details table. This code is in a module activate from a variety of points.