how to add value of subform's textbox to a textbox on main form

[BrockWade]

I have a subform called qryDITtotal with a textbox called DIT2 that exist on a form that has two textboxes on it... I need to add the values upon pressing a button... any cluses as to what I am doing wrong here?: Thanks!

Private Sub btnTotal_Click()
Me.txtCalculatedBalance = Child30.qryDITtotal.DIT2 + Me.txtSubTotal


End Sub

[pbaldy]

See if this helps:

Forms Refer to Form and Subform properties and controls

[June7]

Tried biting my tongue and not saying anything but that hurts so here's my two cents:

This looks like saving calculated value. Saving calcuated data is usually a bad idea, especially aggregate data like balances and sums. Ideally, aggregate data should be calculated when needed, not saved to table.