I'm using Access 2010, and have been having an issue with report filters. I'm creating some flexible reports that let the user filter by year or location, then the next time they can apply different filters, that kind of thing. The problem is that some of these filters seem to be sticking. I do not have filter on load turned on, but some reports seem to get stuck with a filter...for example, one user filters the CYear field to be 2011. I go into the report later, and CYear is set to 2011, with no option to clear filters. I'm doing everything with the interface, so I'm not coding anything in to capture them...any thoughts as to what is going on, and how I can release these invisible filters and get my reports back?
My solution so far is to re-create the report, which works, but is certainly less than ideal. And I cannot recreate the circumstances consistantly. Sometimes when I save a report while designing and having filters set, this happens, sometimes not.
My solution so far is to re-create the report, which works, but is certainly less than ideal. And I cannot recreate the circumstances consistantly. Sometimes when I save a report while designing and having filters set, this happens, sometimes not.
Last edited: