Solved Subform filter quite working: Object or class does not support the set of events, RTE: 459 (1 Viewer)

[mjdemaris]

Hello all,
I just deployed an update to our FE, and this code throws the error mentioned in the subject line:

    iFilter = TempVars!tv_SelectedUserDept
    Me.DS.Form.filter = "[DeptID] = " & iFilter
    Me.DS.Form.FilterOn = True

It has been working fine for a long time. The value filtered on, in my case, is 6. And I am sure I did not touch this bit of code for the update.

(And, it looks like another error expressing the same Object/class message appears on another event.)

Well, if you have any insight as to what might cause the

Me.DS.Form.Filter

to not work, I'm listening.

Time for more testing!

Thanks,
Mike

 

[Gasman]

I seem to recall that you need to use the .Value property with TempVars?
Have you walked your code and inspected values?

 

[mjdemaris]

I seem to recall that you need to use the .Value property with TempVars?
Have you walked your code and inspected values?

Not necessarily. I have been using them quite extensively without the .Value property without any issues. Checking the values was the first thing I did, aside from pulling some hair out . However, I did discover that Access needed a Recompile
I suppose it had been too long since the last one, lol.
Thank you, Gasman.