subform totals

[M Skopinski]

I have four subforms on a main form each having it's own total of items
listed on the sub. How do I get the grand total to be listed on the main
form?

I have tried =[Forms]![tblBreakfast
subform]![BreakfastTotal]+[Forms]![tblLunch
subform]![LunchTotal]+[Forms]![tblDinner
subform]![DinnerTotal]+[Forms]![tblSnacks subform]![SnacksTotal] in the
control source property but that gives me a #name error.

Any help would be appreciated.

email if you can (e-mail address removed)

 

[Leslie Hanna [MSFT]]

Hello Milton

Sounds like you are most of the way there, but the way you are referencing
the the controls on the subform is not correct. Take a look at this article
for a worked example using Northwind.

208998 ACC2000: How to Bring a Subtotal from a Subform to a Main Form
http://support.microsoft.com/?id=208998

Best regards
Leslie Hanna

This posting is provided "AS IS" with no warranties, and confers no rights.