Full Version: How to make Filter work?
UtterAccess Forums > Microsoft® Access > Access Forms
Pablito
Hello, dear connoseurs.
Next emaple is working:
CODE
  Private Sub cboQuickSearch_AfterUpdate()
   Me.Filter = "[chrProductID] = '" & Me.cboQuickSearch & "'"
   Me.FilterOn = True
End Sub

tried to change it to next versions, and it doesn't work.
How to fulfill such filters?
CODE

Me.Filter  = "[chrDescription] Like *" & Me.txtFilter & "*"
Me.Filter  = "[chrDescription] Like *'" & Me.txtFilter & "'*"  ' With apostrophes added

e.g.:
[chrDescription] Like *spo*
[chrDescription] Like *'spo'*
DougY
Welcome to Utter Access Forums!
How about:
CODE
Me.Filter  = "[chrDescription] Like '*" & Me.txtFilter & "*'"

[chrDescription] Like '*spo*'
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.