Disable form filter using expression MS Access

Question

So on one form I have a button than opens a filtered form based on a combobox on the previous form. Works fine. But on the opened form I also have combobox for selecting records - which doesn't work when the form is filtered. I would want to disable the filter when user selects record in that combobox.

Is there a way to disable the form filter using expression in onChange event?

For example:

=[FilterOn]=False

or

=[Filter]=""

These don't work for me though. Thanks

Answer 1

Cannot be an expression like that in event property. Could build a VBA custom public function with code to neutralize filter and call function in event property. It would be complicated because have to pass form name or form object as argument of function =ClearFilter("formnamehere"). I have not developed function code and really don't think this is best approach.

In most cases, when OnChange event is used, really should be AfterUpdate.