Hi, I've got an object (called "Super" below) declared as private in a form class ("Form_frmMyForm"). However, it doesn't seem to retain its value after the Form_Open. In the VBE Watch window the value of the object (Super) is marked "<Out of context>" immediately after the Form_Open sub ends. Why is this?
Code:
Option Compare Database
Option Explicit
Private Super As New FormSummary 'FormSummary is my own custom class
Private Sub Form_Load()
Super.OnLoad
End Sub
Private Sub Form_Open(Cancel As Integer)
Set Super.Base = Me
Super.EntityType = "Objects"
Super.KeyField = "ObjectID"
End Sub
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.ModifyCount.Value = Me.ModifyCount.Value + 1
Me.ModifiedTime.Value = Now()
End Sub
Private Sub ObjectID_Click()
Super.FormDetailsOpen
End Sub
This has been a real pain since I need to use member properties like Super.EntityType later, which after Form_Load evaluates to Null. Worse, since my FormSummary class contains member objects that I refer to, I keep getting
Code:
Run-time error '429'
ActiveX component can't create object.
I've even reinstalled Access originally thinking this was due to missing library references.
Thanks for your help.