Problems clearing Me.Form.Filter

Hi

Using Access 2010

Here is the code.

    Me.Form.Filter = ""
    Me.FilterOn = True

I would expect the value of me.Form.Filter to be =  "".
I would expect for the filter would allow everything even though the filter is still on.

Instead, the value of Me.Form.Filter seems unaffected by this code.  The old filter condition remains.
peispudAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try

me.filter=""
me.filteron=true

or
me.filter=""
me.filteron=false

also, open your form in design view and delete whatever is in the filter property, save the form and try the code again
0
 
Rey Obrero (Capricorn1)Commented:
me.filteron=false  ' will show all records
0
 
peispudAuthor Commented:
Will that be enough though?

I am concerned that I am not controlling the value of me.Form.Filter

So if Me.Form.Filter = "" doesn't work,  will me.Form.Filter = "Someting here"   work every time?

is Me.Form.Filter = "" valid code?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Rey Obrero (Capricorn1)Commented:
<Will that be enough though?>
why don't you try and see for yourself..
0
 
peispudAuthor Commented:
I am concerned that I am not controlling the value of me.Form.Filter

This is really what I meant by "Will that be enough though?"

If I can't purge the form filter with              Me.Form.Filter = "",  then  something is up.  It's bad code or a bug or something.

If I don't understand  why Me.Form.Filter = "" doesn't work, then I cannot be 100 percent sure that any other value that I assign to me.Form.Filter will work under ever circumstance / every time.  

I believe that my question was valid.
0
 
peispudAuthor Commented:
Thank you.   I appreciate your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.