Calculate sum control source

[shank]

I've got a form, with a 2-page control source, with a subform on page 2.
Form = ERM
Control Source = Control1
SubForm = OrderSubform2
TextBox on OrderSubform2 footer = SumOrderAmt (=Sum([OrderAmt])) (shows
correct amt)
I want to display the Sum on the main form = ERM!TAmt

=Control1!Forms!OrderSubform2!SumOrderAmt

I get #Name?

How do I reference that footer box onto the main form?

thanks!

 

[strive4peace]

=OrderSubform2.form.SumOrderAmt

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*