Calculate sum control source

  • Thread starter Thread starter shank
  • Start date Start date
S

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!
 
=OrderSubform2.form.SumOrderAmt

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