serverfilter property is retained by the form

  • Thread starter Thread starter Rodolfo Rughi
  • Start date Start date
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
 
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
 
Back
Top