I am trying to make a running summary form/subform that will just have controls displaying running totals/average/percentages etc. The first one is giving me some problems however in that all I can get it to display is #Error.
For the control source, within the expression builder I am going down the chain of references to the exact forms and controls I am trying to summarize. Here is what the expression builder cobbles together;
=Sum([ProjectTotalsQrySub].[Form]![ExtensionTxtBx])
That however throws the #Error. The referenced text box has the calculation =[SumOfQty]*[Unit Price]. To go even further, [Unit Price] is a calculation being done within the source query of the sub-form.
Can I not do this the "simple" way via expressions in controls?
For the control source, within the expression builder I am going down the chain of references to the exact forms and controls I am trying to summarize. Here is what the expression builder cobbles together;
=Sum([ProjectTotalsQrySub].[Form]![ExtensionTxtBx])
That however throws the #Error. The referenced text box has the calculation =[SumOfQty]*[Unit Price]. To go even further, [Unit Price] is a calculation being done within the source query of the sub-form.
Can I not do this the "simple" way via expressions in controls?