Nick, that's a very helpful tip. Thanks. Rather than me watching a few videos and trying to copy the VBA, I really need to stop and think about each line and what the syntax means, and possibly post each segment of what i'm writing here for cross-proofing until it makes sense in my head. I'm getting through several pages a night reading VBA from the Access Bible. They really break the coding down nicely. I also was also corrected from another forum that my code in this instance should read:

Private Sub btnSearch_Click()


Me.Filter = "AssetNameFK LIKE '*"& Me.txtSearch &"*'"
me.filterOn= True

End Sub

I also read why Filter is important to use because it's a Form property. These little bits of knowledge make a big difference.