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.