> Activate gets fired every time the form gets focus. The only reason I could think of is if the filters where based on a global var and another form changes the global var when they go back to this form the Activate would change the filters on the tables. If that's not the case I think moving to the init would work. You could always move it to the init to debug then put it back in the activate once you found the bug.
I believe you do correctly identified the reason.
I'll go with your suggestion, put the current activate code in #IF .F. for now and move it to Init.
If it's not broken, fix it until it is.
My Blog