-
Help Building First Code as a Keyword Search
Hi, I've watched a video, trying to copy it in producing a keyword search for one of my fields and am getting a little lost with the syntax. Just wondering if someone may be able to help me with this learning curve.
My data field is called AssetNameFK
I've created a text search box and a Search button to activate it.
The string I've been watching looks roughly like this:
Private Sub btnSearch_Click()
Dim SQL As String
SQL = "SELECT AssetNameFK"
"WHERE AssetNameFK LIKE '*"& Me.txtKeywords &"*'"
me.txtKeywords = SQL
End Sub
This is currently not working. I've also been given the following code, but am unsure where to place this or even what it means.
me.filter="AssetNameFK Like '" & strSearch & "*'
I'm hoping someone might be able to help me clean this up. Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules