Running a large 2003 database in compatibility mode. I have always used in
VBA FilterOn =False at the open form event to remove previously applied
filters. Also some forms I use DoCmd.ApplyFilter to open active records
only.
Worked OK for years but now in 2007 I get a message telling me that forms
cannot be found or if a query is the filter it cannot be found. Forms
open
perfectly if I remove VBA code filters from the Open or Load events.
If I use a Macro ApplyFilter to open the forms they open with a filter no
problem.
Building a replacement Database in 2007 so I am hoping the issue only
affects the compatibilty mode. Any ideas? I have a feeling using the On
Error resume next statement with a filter in the load event may just work!
I
notice you get an error message but the filters operate in lthe load
event.
