text search options 1

[GelC]

Hi all,
I'm trying to build a search function base on text fields with options of all words, any word, or exact match.
I searched in this forum but I have no luck yet.
Could someone please give me some help please?

GelC

 

[Remou]

The way it usually works is you post some code and someone here helps you straighten it out, if it catches the eye.

 

[evalesthy]

Something like this snippet:

If Me.frameSearch.Value = 1 Then 'Last Name
If Me.FrameLikeExact.Value = 2 Then 'Like match
strWhere = " WHERE [Subscriber Master]![LastName] Like '*' & '" & varSearchStr & "' & '*'"
Else 'Exact match
strWhere = " WHERE [Subscriber Master]![LastName] = '" & varSearchStr & "'"
End If

 

[GelC]

evalesthy,
Thanks for your starting point.