This should be some <bad word> simple code. I know I have done it in the past but it isn't working. I'm building an Access 2007 DB just for practice, It's been compacted and repaired. The control names have been changed from the field names.
In the form footer I have an unbound text box and a button. The idea is to enter text into the box and then click on the "Filter"
button and then it will limit the items on the form based on the string. When I click on the "Filter"
button I get nothing, but I know there is data that contains the keywords.
I even went through and installed the 2K7 SP3 and it is still failing.
Private Sub FilterOn_Click()
Dim FltrStr As String
FltrStr = "[QuoteStr] Like " & Chr(34) & "*" & Me.FltrTxtBox & "*" & Chr(34)
.Filter = FltrStr
.FilterOn = True
Some of the filter examples:
[QuoteStr] Like "*press*"
[QuoteStr] Like "*law*"
[QuoteStr] Like "*christmas*"