Totals from subform to main form

[kathi2005]

I have two separate forms that have embedded subforms where I need totals to show in the main form. For one of the forms it is working great. On the other form it is not working.

The field on the subform is a calculated field (LineTotal):
=[MSRP]*[Quantity]
this works, but when I put when I put
=Sum([LineTotal]) in the footer it is returning an error

I thing if I can figure out my mistake here I can get through the rest of this

[boblarson]

It isn't a calculated FIELD it is a calculated CONTROL. So you need to use the same fields:

=Sum([MSRP]*[Quantity])

[kathi2005]

That was too simple. The total works on the subform (field name is DetailTotal) but when I use

=[Forms]![SODetailExtended Query subform]![DetailTotal]

in the main form I get the #Name? error

[boblarson]

That was too simple. The total works on the subform (field name is DetailTotal) but when I use

=[Forms]![SODetailExtended Query subform]![DetailTotal]

in the main form I get the #Name? error

Don't use that method. It is probably going to want

=[SODetailExtended Query subform].[Form]![DetailTotal]

(and it isn't field name, it is TEXT BOX NAME, correct? Fields are in tables and queries and controls are on forms and reports and can be bound to fields. It is important to not use the word field interchangeably - even though I find myself falling into that same trap occasionally as old habits die hard)

Now if the suggested control source that I gave doesn't work, I find this method to be the easiest to get the right value there:
http://www.btabdevelopment.com/ts/refer2sfrms

[kathi2005]

once again that was too simple.

hopefully with what you have taught me today I can finish this thing