Forms And Subforms

[Lacey]

--I have a main form that contains two datasheet subforms. I would like to
move the footer totals from the second subforms to the main footer totals.
How can you see if my formula is right in the second subform?
Also my total in the main footer is getting #Name. Do I need to link it
from the main form, then the first subform, then the second subform. I keyed
main form and second subform name only and I get in the main form footer
#Name error.
I am new at this.
Thanks

Lacey

 

[Duane Hookom]

Please provide the names of your subforms and the controls from the subforms
that you want displayed on the main form.

 

[Lacey]

-- Duane,
The first subform is CustomerSalesOrder, the second subform where I want the
Totals in the footer is called Subform IndividualItemsSoldtoCustomers the
controls for this subform footer are
The controls in IndividualItemsSoldtoCustomers are
Sales/Invoice#ID
SaleDateProduct/Service#ID
Comment
QuantitySold
PriceperUnit
TaxableAmount if no tax is 0
Total is calculated =([QuantitySold]*[Priceper
Unit])

The controls in the footer for IndividualItemsSoldtoCustomers are

TaxTotal =Sum([Nz([TaxableAmount].0)
SalesTax =Sum([TaxableAmount]*0.06)
GrandTotal =([TaxableAmount]*0.06+[QuantitySold}*[PriceperUnit])

The main form is called Customer Addresses where I want the total move to.

Thanks
Lacey

 

[Duane Hookom]

Try a text box on your main form with a control source of:
=IndividualItemsSoldToCustomers.Form!GrandTotal

--
Duane Hookom
MS Access MVP
--

-- Duane,
The first subform is CustomerSalesOrder, the second subform where I want
the
Totals in the footer is called Subform IndividualItemsSoldtoCustomers
the
controls for this subform footer are
The controls in IndividualItemsSoldtoCustomers are
Sales/Invoice#ID
SaleDateProduct/Service#ID
Comment
QuantitySold
PriceperUnit
TaxableAmount if no tax is 0
Total is calculated =([QuantitySold]*[Priceper
Unit])

The controls in the footer for IndividualItemsSoldtoCustomers are

TaxTotal =Sum([Nz([TaxableAmount].0)
SalesTax =Sum([TaxableAmount]*0.06)
GrandTotal =([TaxableAmount]*0.06+[QuantitySold}*[PriceperUnit])

The main form is called Customer Addresses where I want the total move to.

Thanks
Lacey

Please provide the names of your subforms and the controls from the
subforms
that you want displayed on the main form.