Access Project and Server Filter

[Zirak]

I am having a strange problem with the Server Filter property of one of my forms.

In some cases, after I filter my form programmatically the filter remains even after I close the form on its Server Filter property.

I even have a code to set the Server filter to nothing and it still has the same problem.
I have used the following codes on the "On CLose" event og my form:

On CLose:

Me.FilterOn=False

I also tested:
ServerFilter=" "

Can anyone help me?

 

[tlbroadbent]

Use Me.ServerFilterByForm = False If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[cmmrfrds]

This worked for me when I ran into the same problem a while back.

Private Sub Form_Close()
Me.ServerFilter = ""
End Sub