Sum of the Sum

[an]

Hello!

How is possible to Sum in TextBox on FormFooter on
MainForm, when the TextBox values to Sum on Detail Section
on MainForm, are already arising from another TextBox with
Sum on FormFooter on SubForm, please?

I tried a similar formulae wich on SubForm (where work
fine) but return #Error in TextBox.

Thanks in advance.
an

 

[BruceM]

I'm not quite following your question, but if you are trying to reference a
subform control such as a text box you will need to use something like the
following:
Forms!frmMainform!fsubSubform.Form!txtTextbox
Substitute the actual names you are using, of course. If this does not
address your question, please repost with more specific information about
what you need to do.

 

[an]

I have thankful for the reply.
I go to try to explain.

MainForm - Table1 - Id1
SubForm - Table2 - Id2 where Id1 to many Id2
SubSubForm - Table3 - Id3 where Id2 to many Id3

SubSubForm - Text box on Form Footer where sum Values of
the numeric field. Work fine.
SubForm - Text box, on Detail section, with resulting from
text box of the Form Footer on SubSubForm. Work fine.
Now
MainForm - I would like to sum the values, resulting of
sum's on the SubForm, where the Id is the same: On SubForm
and MainForm
I don't know if I will have been explicit...

Thanks more one time.
an