ServerFilter

[GammelNok]

Hi
I am trying to get over the Docmd.ApplyFilter problem in my adp database, backended to SQL2000.

The following code does not filter my form

any ideas welcome

Private sub cmdLeft_Click()
Me.ServerFilter = ""
Me.ServerFilter = "teamEmpStatus = 'Left'"
Me.ServerFilterByForm = True
end sub

 

[cmmrfrds]

I did that on an App, but don't have it with me.

I believe I did.

ON OPEN Event of Form
Me.AllowFilters = True
Me.FilterOn = True
Me.ServerFilter = "teamEmpStatus = 'Left'"