Expression refers to an object that is closed...WTF?

[dniezby]

Okay, so I'm using code I've used a GAZILLION TIMES. What the heck is going on? I keep getting an error that says,



"The expression you entered refers to object that is closed or doesn't exist." Runtime error 2467

Here is the code:

If Not Me.NewRecord Then
Me.ModifiedDate = Now()
End If


ModifiedDate isn't a reserved word is it?

I have used this code forever. On my form I have a control named ModifiedDate that gets updated when there is a modification to the data is not a new record. It is also disabled for user access so they can't change or edit it, but it has never affected code updates before.

Can't explain why it's causing this problem.

Any thoughts?

[Bulzie]

Where are you running the code, if in OnOpen try OnLoad instead.

[dniezby]

Where are you running the code, if in OnOpen try OnLoad instead.

Opps sorry, there is all of the code there. It ALL exists too.

Private Sub Form_BeforeUpdate(Cancel As Integer)
'If the updates are not a new record, update the ModifiedDate control.
If Not Me.NewRecord Then
Me.ModifiedDate = Now()
End If

'If SBC ID is blank, post a message box error.
If IsNull([SBCUsername]) Then
MsgBox "You MUST have a User ID to continue."
End If

End Sub