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
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