SUBTOTALS using subform in a form

[Ma3x323]

OK I got all these items in a subform and on the last column is a Price field. The subform is in tabular form. The subform is in a form and on the footer of this form is of course : SUBTOTALS : ___________
TAX: ___________
GRANDTOTAL: ___________

Now, I can do the tax and grandtotal based on the subtotals. But how do I code the text box for Subtotals so it adds all the prices of the items in the subform?
Any suggestion is a great suggestion.

Thanks,
Feryl

 

[CosmoKramer]

Feryl,

There may be an easier way, but this is how I accomplished it:

I defined a non-visible text box (txtSumPrice) in the footer of the subform that had as its control source: =sum([price])

Then, in the form I have a text box with the following as its control source: =[frmPrice subform].[Form]![txtSumPrice]

 

[Ma3x323]

Thanks Cosmo. I don't even know why I didn't think about that. Awesome idea.
I had to use VDA coding to do it but it had lots of flaws.