Access - Clear Filter Selection Not Working

I have a table where when I enter a value for a parameter value to filter select rows, I want to clear the filter, but the "Clear Filter" option with the picture of the funnel with the red X is greyed out. So, I have to close the table and re-open every time I just want to clear the filter.
exp vgAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
is this a local table or a linked ODBC table?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sounds like your working with a query, not a table.   What would need to happen is the parameter value would need to change, which in this case can only be done by closing and re-opening.

 A filter is something separate.  It's something that can be applied on top of  the base data.  That's why the clear is grayed out; you haven't applied one.

exp vgAuthor Commented:
Local table. I am not working with a query - it is a self standing table. It was working before - not sure why not now.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Rey Obrero (Capricorn1)Commented:
do a compact and repair, then try again
you can also use the Select All option from the listbox
exp vgAuthor Commented:
Will this happen if the table I am using has been from a Make Table query?
Rey Obrero (Capricorn1)Commented:
a local table is a "table", no matter wherever it came from, it could be imported, created by design, created from a make table query.
so it is No. It should not happen.

does the same problem showing to other tables?
exp vgAuthor Commented:
Can this happen if it is imported from Excel?
Jeffrey CoachmanMIS LiasonCommented:
Lets take a few steps back,...
It is not clear if you did as Rey instructed here
You have not answered his question here either

Can this happen if it is imported from Excel?
See Rey's post here
A table is a table, ...

What you are describing is not normal, either you are doing something different, ...or something is wrong with your database or Table.
So it may help if you posted the exact steps you are performing, and included screenshots.

But please reply to all of Rey's questions first please.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.