serverfilter property is retained by the form

[Rodolfo Rughi]

if I open a form using docmd.openform "form name",,,"where cond", in certain
conditions, the where is saved by the form in the serverfilter condition and
successive opening of the same form, give always the same filter.

Is it possible to avoid this ?

thanks

 

[Rodolfo Rughi]

just a little work around: before ship my application I execute:

Function scan_forms() As Boolean

Dim mf As AccessObject

For Each mf In Application.CurrentProject.AllForms
DoCmd.OpenForm mf.Name, acDesign
Forms(mf.Name).ServerFilter = ""
DoCmd.Close acForm, mf.Name, acSaveYes
Next mf

End Function