Changing VBA to do more

[data808]

This is the VBA code I have running at the moment:

Private Sub cmdFilter_Click()

Me.Filter = "[initials:]='" & Me.txtFilter & "'"
Me.FilterOn = True


Me.Requery

End Sub

Private Sub cmdUndoFilter_Click()

Me.FilterOn = False
Me.Requery

End Sub

I would like to change this from filtering only the "initials:" field, to filtering all fields. I would like the user to type in all or partial values. When they click the filter button, whatever was typed into the text box, I want all records with some or all of that value to show and everything else gone. Does anyone know how to do this? I have date, number, and text fields in this database if that matters. Thanks for the help in advance.

[June7]

This is a duplicate thread https://www.accessforums.net/forms/v...ing-41238.html