totals

[Cori]

is there a way that i can get a total from a number on a form and a number on a sub-form (I want to add the numbers from the form and sub-form and have the total appear in a text box on the form)

 

[Fear Naught]

Create a text box in the footer of the sub form to showthe totals of whatever column you are totaling. On the main form create a text box that has shows the sum of the data from the subform text box to the object on the main form.

 

[Cori]

Ok i did that, but i am not sure what formula or wordage i am supposed to use to get it to recognize the text box total on the sub-form...sorry i am new to this.

 

[uplate]

Play around with something roughly like this and you should get there:

Me.txtTotal = Me.txtMainFormVal + Me.fsubSubform.Form.Section(acFooter)!txtSubformVal