Help Building First Code as a Keyword Search

[101]

Cheers OBP. Thx. have a good night.

I've amended by code to:

Private Sub btnSearch_Click()
Dim SQL As String

SQL = "Me.Filter = AssetNameFKwhere AssetNameFKLIKE '*"& Me.txtSearch &"*'"
me.filterOn= True

End Sub

I tested this with no result.

I also looked up https://docs.microsoft.com/en-us/off...lter(property) and now understand that a Filter is a form based property. Now I'm starting to understand.