Update Calculation When Opening Form

[pwmichael]

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.

[Welshgasman]

On open would be no good, but I would have thought On Load would have worked as subforms load first

Perhaps the OnActivate event?, or even the OnCurrent would be better, as it will update when you change main record?

[Micron]

The reference doesn't look right for those events but not sure as different words/names are being used to describe the same things?
Try syntax of

Forms!MainFormName!SubformControlName.Form.ControlName

SubformControlName is the name of the control that holds the subform. Don't change the red parts.
If you're storing this calculation, generally that is a no-no.