Trying to total some values from a form and a subform

[anoble1]

I am having an awful time trying to get a grand total.
Any help on how I can total these values using code outside a query?

I can't even get a total from this form. I tried putting a sum in there and it will not work.

=[frmPODetails].[Form](Sum([txtTotalPrice]))

[pbaldy]

Have you tried this in a textbox in the footer?

=Sum([txtTotalPrice])

[anoble1]

Just tried it. Same problem. Says Error on the bottom still.

If it helps the txtTotalPrice is a calculated text box through vba.

Have you tried this in a textbox in the footer?

=Sum([txtTotalPrice])

[aytee111]

The total uses fields that are on the record source of the form, so if you want to put the expression into the control source of this total then it must refer to fields in the record source, not fields on the form. If it needs to be calculated differently, then you will have to do it in code, same as the txtTotalPrice.

[anoble1]

Got it. I think that was the problem. What I did was created a new textbox that formed a total of the sub report Form Footer. Then took that total and created a grand total on the Main Form Footer. Seems to work fine now. Thanks for the help.

The total uses fields that are on the record source of the form, so if you want to put the expression into the control source of this total then it must refer to fields in the record source, not fields on the form. If it needs to be calculated differently, then you will have to do it in code, same as the txtTotalPrice.