Linking Tables and create a running total

[mommom]

I am creating a travel form which needs to be linked to another travel form. Need to be able to have the ending balance pull over to the beginning balance on a new form. Any help will be appreciated.

 

[shreked]

mommom

what you need to do is refernce the other form here some sample code

Private Sub Form_Open(Cancel As Integer)
Dim Frm As OLDFORM
Set Frm = OLDFORM
Me.EndingBalance = frm.EndingBalance

End Sub

OLDFORM is the form you are coming from
Me.EndingBalance is the the textbox name on the new form
Me.EndingBalance is the the textbox name on the old form

Hope this help if not let me know

Shrek