I want the Subform total in a textbox in the main form

[Joenachos007]

I want the Subform total in a textbox in the main form.

I got a subform with invoice number and for each invoice I got a total on
each line. I want the sum of each line in the Total column to show in a text
box on the main form.

 

[Dorian]

You set up a control in the subforms foooter to contain the sum of the
subform items Then you refer to this footer control from your main form.

-Dorian

 

[Joenachos007]

that is what I did and I put =[Invoice subform]![Text12] in the textbox in
the form, but it shows " #Error " , my formula is not good.