exp vg
asked on
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.
Rey Obrero (Capricorn1)
is this a local table or a linked ODBC table?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Local table. I am not working with a query - it is a self standing table. It was working before - not sure why not now.
do a compact and repair, then try again
you can also use the Select All option from the listbox
you can also use the Select All option from the listbox
ASKER
Will this happen if the table I am using has been from a Make Table query?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can this happen if it is imported from Excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.