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

mjdemaris

Working on it...
Local time
Today, 11:12
Joined
Jul 9, 2015
Messages
426
Hello all,
I just deployed an update to our FE, and this code throws the error mentioned in the subject line:
Code:
    iFilter = TempVars!tv_SelectedUserDept
    Me.DS.Form.filter = "[DeptID] = " & iFilter
    Me.DS.Form.FilterOn = True

1712941080720.png


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
Code:
Me.DS.Form.Filter
to not work, I'm listening.

Time for more testing!

Thanks,
Mike
 
I seem to recall that you need to use the .Value property with TempVars?
Have you walked your code and inspected values?
 
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 :rolleyes:
I suppose it had been too long since the last one, lol.
Thank you, Gasman.
 

Users who are viewing this thread

Back
Top Bottom