Switching from Microsoft Office 2003 to 2007 has not been fun.
The most painful part has been Access.
I had a form button that ran a macro that used ApplyFilter on a query based on form inputs. It always worked great in Access 2003. In Access 2007, it wouldn’t run. It didn’t give any errors. It didn’t do anything. All the online resources said the macros were blocked because of security. Nope.
So I finally determined that in the main form the “Filter On Load” property was changed from No to Yes. No reason. It was just changed. I changed it back to its proper setting of No, and it works again.
