I have an access 2010 report filter problem
In VBA I created some code to filter my data.
When I open the report the data is not filtered. However, if I immediately go into design view then
back to report view the data IS filtered. So I know it works.
Also, if I check the report properties, I can the correct filter and FilterOnLoad = yes
Is this a timing issue?
I have tried moving my code from OnOpen to OnLoad to OnActivate. Same thing happens
When I initially open the report, no filtering, but if I go into design view then back to report view, the filter works
I welcome your comments