Form total from subform total

[Dee via AccessMonster.com]

I am creating an order entry-type database and am having problems bringing
totals from my subform footer (which works fine) into the main form.

I have used the following (which has worked with other forms/subforms -
thanks to Larry), but for some reason the cell is blank with the one I'm
working on (no errors).

Sub Form Name = OrderDetailsSubForm
Text Box Name = CustomerTotal (footer in subform)
Main Form Name = Orders

=IIf(IsError(Forms!Orders!OrderDetailsSubForm.Form! CustomerTotal),0,Forms!
Orders!OrderDetailsSubForm.Form!CustomerTotal)

Help Please!!

 

[Wayne Morgan]

OderDetailsSubForm should be the name of the subform control on the main
form, not the name of the subform; however, they may both be the same name.
Also, assuming you copied and pasted the equation into the message, you have
an extra space in the IsError function just before CustomerTotal.