Access will not allow me to delete a filter!!

[johndoh!!]

When my kids don't listen, i understand. When my pute won't listen i pull the few remaining hairs from the top of my head!!!

I have a filter in a report that has a subreport which itself has a subreport. I modify the filter on the main report and it works perfectly! I save the report, close the report, then open the report... and that damn filter is back... without the modifications!!!

I have turned the filter off first, then delete the filter, it comes back. I have turned the filter off, then modified the filter, it comes back. I really do not want to delete the entire report and start over but it appears that is the only way to beat Microsoft this time... and no sure thing either.

Any help would be GREATLY appreciated!!!!!

Grrrrrrrrrrrrrrrrrrrrrrrrrrrrrr!!!

 

[David R]

Look at the Properties page for all the reports involved. Are there unknown Filters lurking? Check the statements which open the Reports (I assume you're not opening them directly from the Database Manager screen). Look at the code for Load, Open, etc for mentions of a rogue filter.

Computers generally do exactly what you tell them to. It's that they're so damn LITERAL that's the issue...

"Do as I say, not as I do!"
David R

 

[johndoh!!]

THANK YOU!!!!!!!!!!!!!!!!!!!!!!

A filter in the onclick for the button that opens it... it only confirms how STUPID i am!!!!!

Doh!!

 

[David R]

Nah, I only know cause I've had Access save things like filters and sort orders when I had no intention of doing so...

Important thing is, you now know where to look next time.

Good luck,
David R