Hello everyone
I have the next issue
I want to filter a database based on the info typed into the text box, after this, clicking on the button search and filter the database...
I have an issue in my code, because I know just how to filter it based on a field but not for all....
The fields I have are: Batchnumber, ModelnumberID, OperadorID, Datet, TestResults, Units and Status
My code is:
Me.Requery
Me.Filter = ""
Me.FilterOn = False
If Me.searchtxt <> "" Then
Me.Requery
'That's my issue:
Me.Filter = "[*] like " & Chr(34) & "*" & searchtxt & "*" & Chr(34)
'I know normally should be here the [*] = [Fieldnumber], but how must be established for all the fields?
Me.FilterOn = True
End If
Thanks in advance for the support!!!!