Search box that shows result in Form

[June7]

Text is the wrong property. Value is correct property. It is also the default for data controls and need not be typed.

Doesn't work because you haven't parsed the string into individual word components and concatenated to criteria string. Requires an array and looping structure. Something like:



Dim aryWords As Variant, i As Integer, strFilter As String
aryWords = Split(Me.wpssearch, " ")
For i = 0 to UBound(aryWords)
strFilter = strFilter & "Description LIKE ""*" & aryWords(i) & "*"" OR "
Next
strFilter = Left(strFilter, Len(strFilter) - 4))
Me.Filter = strFilter
Me.FilterOn = True

[revvedmoto]

Great!! That fixed that. Again thanks for all the help June.

Here's the code for anyone else that runs into the same issue

Private Sub wpssearch_AfterUpdate()
Dim aryWords As Variant, i As Integer, strFilter As String
aryWords = Split(Me.wpssearch, " ")
For i = 0 To UBound(aryWords)
strFilter = strFilter & "Description LIKE ""*" & aryWords(i) & "*"" AND "
Next
strFilter = Left(strFilter, Len(strFilter) - 4)
Me.[wps subform].Form.Filter = strFilter
Me.[wps subform].Form.FilterOn = True
End Sub