Thanks for your patience!
To answer your questions- The information in the "Products Subform" is all fields directly linked to the tables (no query). The only calculated fields on that subform are the two in the footer which give me the total "WeightOnHand" and QuantityOnHand" for each item.
My subform is named "Products Subform" and the form that I am trying to do the total calculation on is "Product Value". So do I understand you correctly? I need to use
Me!Products Subform.Product Value
Where do I put this?
Also, I need to multiply "WeightOnHand" times "UnitPrice" before I can sum it (if I cannot use the "TotalValue" field to get my grand total). "Unit Price" is a bound box that comes from a table. But "WeightOnHand" comes from an unbound box with a calculated value in the subform. Are you saying that I need to use the whole formula from the "WeightOnHand"
=Sum(nz([WeightIn])-nz([WeightOut]))
So will it look like this?
=Sum(nz([WeightIn])-nz([WeightOut]))*([UnitPrice])
At this point, that still gives me the #Error message - but I have not put in the Me! statement yet, since I don't know where to put it.
Thanks
Luann