total of subform's subtotals

  • Thread starter Thread starter Chris Ryner
  • Start date Start date
C

Chris Ryner

I have frmTENANTMST with a subform RENTONLY (frmRENT) and a subform
ADDTIONAL (frmADDER).

both of the subforms have subtotal's in the footer: textboxes
SubtotalRent: =sum([sqft]*[rate]) SubtotalAdder: =sum([qty]*[rate])

then on the parent form I need a textbox to display the total of the two
subtotals.

TOTAL: = ([frmADDER].[form]![subtotaladder]) +
([frmRENT].[form]![subtotalrent])


I have tried adding NZ to the subtotals and to the total to no avail.

When both of the subforms have records there is no problem but when one or
both have no records the TOTAL displays as #Error.


What Can I do?
 
I was having similar problems querying totals form
subforms, especially were it was not necessary to fill in
a subform. Check the relationship properties in the query,
and change it so that all of the parent records are
displayed.
 
Back
Top