Error '459' Object or class does not support the set of events

[Joe]

I have a multiuser database, and we are getting the
following error on only some of the workstations:

Run time error '459':
Object or class does not support the set of events.

Here is the offending code:
Private Sub Form_Load()
Me.Filter = "ItemID = " & Forms!frmItemTab.OpenArgs
Me.FilterOn = True
End Sub

In debug mode, when I hover over the Forms!
frmItemTAb.OpenArgs, the tool-tip displays <Object or
class does not support the set of events>

Since this crashes on only two computers, I assume they
are missing some support object, but the References dos
not show anything "Missing". Any ideas?

-Joe

 

[Jimmy]

I think your filter is off. Try this:

Private Sub Form_Load()
Me.FilterOn = True
Me.Filter = "ItemID = " & Forms!frmItemTab!OpenArgs
'If you want to shut the filter back off, do this:
'Me.FilterOn = False
End Sub

 

[Douglas J. Steele]

I'm not sure you can do it in the Form_Load event. Try putting it in
Form_Open.

 

[Joe]

This procedure works fine on ~40 workstations, but only
two workstations are getting this error, which leads me to
think some objects are missing - what I don't have a clue.
-Joe