I have a main form with a sub form on it. and a subform on that one as well.
The subform's subform has accessories and has these fields: qty, price, exprice.
With exprice being a calculated field of price x qty.
I have a total on the header of this form with this =Sum([ExPrice]) in it's header, all works fine.
Then on it's parent I have these fields: qty, price, accesstotal, exprice, and linetot
With accesstotal being: =[SfrmQuoteAcc].[Form]![txtAccessTotal] This works
And exprice being: =IIf(IsNull([AccessPrice]),[Price],[Price]+[AccessPrice]) This works
and linetot being: =([ExPrice]*[Qty]) This also works
The problem comes in when I try to sum the linetot on the header of the form: =Sum([LineTot]) This produces the error: #Error.
What have I got wrong.
Thanks
The subform's subform has accessories and has these fields: qty, price, exprice.
With exprice being a calculated field of price x qty.
I have a total on the header of this form with this =Sum([ExPrice]) in it's header, all works fine.
Then on it's parent I have these fields: qty, price, accesstotal, exprice, and linetot
With accesstotal being: =[SfrmQuoteAcc].[Form]![txtAccessTotal] This works
And exprice being: =IIf(IsNull([AccessPrice]),[Price],[Price]+[AccessPrice]) This works
and linetot being: =([ExPrice]*[Qty]) This also works
The problem comes in when I try to sum the linetot on the header of the form: =Sum([LineTot]) This produces the error: #Error.
What have I got wrong.
Thanks