Form total from subform total

  • Thread starter Thread starter Dee via AccessMonster.com
  • Start date Start date
D

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!!
 
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.
 
Back
Top