Subform total

[Unicon]

I have a calculated subform in form where in subform in the footer area I put =Sum([GrandTotal]) and its giving me an exact value of -39 after the calculation. I want to show it in form I put correct formula to show that value in form but its showing error. I put =[SfrmCurrentRequirements].Form![GrandTotal]

But its showing ERROR. Please help me out. Is it showing error because of - value???

Please advice.

 

[pbaldy]

You would want the name of the textbox with the sum function in it, not the name of the field (if they're the same, they shouldn't be).

 

[Unicon]

Please see the attachment. I again put textbox name GTotal but still its not working.

 

[pbaldy]

And the formula is now

=[SfrmCurrentRequirements].Form![GTotal]

If so, is SfrmCurrentRequirements the name of the subform or the name of the subform control on the main form? It needs to be the latter.

 

[Unicon]

Thanks pbaldy it's working now. I change the name of subform.

 

[pbaldy]

No problemo!