Solved

Problems clearing Me.Form.Filter

Posted on 2013-02-05
6
431 Views
Last Modified: 2013-02-05
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.
0
Comment
Question by:peispud
  • 3
  • 3
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38857990
me.filteron=false  ' will show all records
0
 

Author Comment

by:peispud
ID: 38858012
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38858045
<Will that be enough though?>
why don't you try and see for yourself..
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:peispud
ID: 38858069
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
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 38858072
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
 

Author Closing Comment

by:peispud
ID: 38858096
Thank you.   I appreciate your help.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question