Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to include like wildcard in search

Status
Not open for further replies.
mrbboy

mrbboy

Technical User
Feb 28, 2007
136
US
I want to build a form that allows keyword searches using a textbox but don't know where to insert the "like" clause.

If Not IsNull(Me.txt_search) Then
Whereclause = "[Details] = '" & Me.txt_search & "'"
End If


Thanks
 
Sort by date Sort by votes
How are ya mrbboy . . .

Perhaps:
Code: 
[blue]Whereclause = "[Details] Like '*" & Me.txt_search & "*'"[/blue]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

I
  • Question
How to get 2 codes to work together.
Replies
6
Views
203
hermanlaksko
hermanlaksko
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
219
Xavierparkash
Xavierparkash
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
485
Kennelbloke
Kennelbloke
caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
286
caykamanj1966
caykamanj1966
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
389
PrimoSteve
PrimoSteve

Part and Inventory Search

Sponsor

Back
Top