Hi,
I have a problem where i have read a lot of information about still i have not found the correct solution for my problem.
I have a form. When i click on right button the and apply a text filter everything works fine. I close the form. Upon opening again the filter is still active and the form property contains the filter in the filter line. Then i need to click again the right button and click 'clear text filter'. What i would like to achive is that upon closing the filters would be turned off and the filter line of the form property would be empty.
Tried on open/on close/on unload/on load the several variation of
me.filteron=false /me.filter="".
The closest was to apply docmd runcommand accmdremoveallfilters. However it can give a run time error.
What shall i do to turn off and clear all filter upon closing the form?
thank you
I have a problem where i have read a lot of information about still i have not found the correct solution for my problem.
I have a form. When i click on right button the and apply a text filter everything works fine. I close the form. Upon opening again the filter is still active and the form property contains the filter in the filter line. Then i need to click again the right button and click 'clear text filter'. What i would like to achive is that upon closing the filters would be turned off and the filter line of the form property would be empty.
Tried on open/on close/on unload/on load the several variation of
me.filteron=false /me.filter="".
The closest was to apply docmd runcommand accmdremoveallfilters. However it can give a run time error.
What shall i do to turn off and clear all filter upon closing the form?
thank you