serverfilter property is retained by the form

R

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
 
R

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
 
Top