Run-time error '2467'
The expression you entered refers to an object that is closed or doesn't exist.
Private Type Record stID As Long stName As String stAge As Long End Type Private Sub DoSomthing() Dim R As Record R.stID = Me.st_ID ' The error occurs here and apparently it applies to the next two lines too. R.stName = Me.st_Name R.stAge = Me.st_age End Sub Private Sub Form_Unload(Cancel As Integer) Call DoSomthing End Sub
From novice to tech pro — start learning today.