Filter Not Clearing properly

Question

Ok,

I want to scream. Sometimes this code works and sometimes it does not.

Me.cboGoTo = Null
Me.Src = ""
Me.FilterOn = False    

Even if I also add Me.Filter=""

It will not remove the filter.

I have already had to recreate many forms due to this failure and I am done doing that.

Can someone please tell me when this code will not work and why?

Thanks

Tammy

Answer 1

Sorry, but I can't offer any explanation for that. Can you post the file to OneDrive or similar, so that we can try to debug the form?

Answer 2

I am saying that the form remains filtered to the last expression assigned to its Filter property.

Nothing will remove this filtering.

I wish your last sentence was true in this situation but it is not.

I tried to copy and paste images so it could be seen, but my snip does not work.

Tammy

Answer 3

Are you saying that the form remains filtered to the last expression assigned to its Filter property, or merely that the expression remains assigned to the Filter property?  If the latter, this is normal behaviour as the Filter property is persistent.  Provided that the form's FilterOn and the FilterOnLoad properties are False the Filter will not be applied unless you specifically set the FilterOn property to True by code or through the built in user interface.

Answer 4

Try this:

Me.cboGoTo = Null

Me.Src = ""

Me.Filter =""

Me.Refresh

Me.FilterOn = False

This did not work. The filter remains.

Thanks

Tammy

Answer 5

Try this:

Me.cboGoTo = Null

Me.Src = ""

Me.Filter =""

Me.Refresh

Me.FilterOn = False