Avatar of Michael Paravicini
Michael Paravicini
Flag for Chile

asked on 

OpenForm does not clear Filter

I use a Sub to open all forms (for validation purpose). One of the parameters passed is lWhereCond. Now I have the situation where lWhereCond is set to "" and yet when I open the form with

    DoCmd.OpenForm lFrameName, lacFormView, lFiltername, lWhereCond, lDataMode, lWindowMode, lOpenArgs

where both lFiltername and lWhereCond are set to "" the filter is still set to "Resid=3" in the Load event of the form (this was the previous filter used).  I am confused why the filter is not reset to nothing and why it still applies the old filter? I am using a form with a subform. Thank you so much for any explanation. Rg Michael
Microsoft Access

Avatar of undefined
Last Comment
Michael Paravicini

8/22/2022 - Mon