access 16, Filter datasheet

[akika]

Hi,

I have several users that are using a form and its displaying the last filter done by another user.
How to reset the filter to display all the records but keeping the filter on specific columns which will be used by the search button?

I'm using a split form and in filter, form properties, have below cmd..

Nz([Name],"") Like "*" & Forms!Details!Text214 & "*" And Nz([Street],"") Like "*" & Forms!Details!Combo224& "*" And Nz([City],"") Like "*" & Forms!Details!Text202 & "*" And Nz([Town],"") Like "*" & Forms!Details!Combo244 & "*" And Nz([Representative],"") Like "*" & Forms!Details!Text246 & "*" And Nz([Status],"") Like "*" & Forms!Details!Combo248 & "*" And Nz([Code],"")

Search button cmd
Me.Requery
DoCmd.RefreshRecord

Clear Button cmd
Me.Text214 = ""
DoCmd.GoToRecord , , acNewRec

[ranman256]

Each user has their own copy of the Front end app , right?
but also, open the form with the filter off at FORM LOAD:
Me.FilterOn = False

make filter:

'----------------
sub btnFilter_click()
'----------------
dim sWhere as string 


sWhere = "1=1"
if not IsNUll(cboST) then sWhere = sWhere & " and [State]='" & cboST & "'"
if not IsNUll(cboCity) then sWhere = sWhere & " and [city]='" & cboCity & "'"
if not IsNUll(cboZip) then sWhere = sWhere & " and [ZipCode]='" & cboZip & "'"

If sWhere = "1=1" Then
  Me.FilterOn = False
Else
  Me.Filter = sWhere
  Me.FilterOn = True
End If

end sub