I want the Subform total in a textbox in the main form "Joenachos007" <u48101[ at ]uwe> 12/10/2008 5:30:32 PM 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.

RE: I want the Subform total in a textbox in the main form Dorian 12/10/2008 8:34:01 PM 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" wrote: [Quoted Text] > 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. > >

RE: I want the Subform total in a textbox in the main form "Joenachos007" <u48101[ at ]uwe> 12/10/2008 8:44:00 PM 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. Dorian wrote: [Quoted Text] >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 > >> 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.