Lost Filter 1

[sxschech]

I have a report where I hard coded the filter criteria. The reason being is that I didn't want to add additional code in case some time in the future the user wanted to modify the criteria and also to eliminate additional queries. The report was working fine and then today, the filter was gone. Since I didn't want to worry about losing the filter again, I ended up creating another query with the equivalent filter criteria. Has anyone experienced losing the filter? Any way to prevent it from going away short of code or query? Thanks for your thoughts.

 

[LonnieJohnson]

If you are talking about the Filter Property in the report's property window, that is not absolutely stable. It's actually more of an inherited property from a query or table. You can hardcode the criteria there, but it can be overriden or erased by changes to the underlying table or query. If you opened the table and filtered some records via the menu or object properties then this could affect your report.

Bottom line, if you want a filter on a report or form you need to create a query or set it with VBA at runtime if you want it to always take effect.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[sxschech]

Thanks for clearing that up. I'll be more careful in how I use filters in the future, I guess some simple solutions aren't always what they seem.