Calculation in SubForm

[Alberto]

I am trying to sum up a series of control boxes in a subform and place the
sum in the footer.

In the subform, I have two separate fields: Units and UnitPrice. These are
also the same fields in the table tblQuoteDetails. I am trying to multiply
Units by UnitPrice and then sum them within the footer. To do this, I have
created a new control within the subform (not in the form footer) entitled
Total Price which is equal to Units*UnitPrice. This calculates properly. I
am now trying to sum up all of Total Price within the Form Footer. However
when I do this I get an error.

Here's what I have in the SubForm:
txtTotalPrice = [Units]*[UnitPrice] this works fine.

Here's what I have in the Form Footer
txtGrantTotal = Sum([TotalPrice]) I get an error message in the form footer
when I do this.

Thank you

 

[Duane Hookom]

You can't sum a control. Try:
txtGrantTotal = Sum( [Units]*[UnitPrice] )