New to Access and need some help (I apologize if I'm using the wrong terms). I have a main form (Security) that contains a subform (LotsSubForm). In the Securities form I have a field named "Basis" that is the sum of a field (basis) in the subform.
I am able to get the "Basis" field to populate when leaving the subform with the On Exit Exit Procedure
Private Sub LotsSubForm_Exit(Cancel As Integer) Me.calcbasis = Me.LotsSubForm!newbasis
End Sub
When I first open the Security form "Basis" is blank and I would like to have it populate with the sum of the "Basis" field in the subform, as it does when I exit the subform. I have tried using the same syntax in the "Security" form with the Event Procedures On Load and On Open but it is still blank.
Any Ideas on what I am doing wrong?
Thanks.