MS Access Substring

I created a search Form for my db. It works great, if you enter everything in 100% the same as the db has it stored. What I want to change is the 100% part. If I enter "Jones" in the address tect box and hit search, I want "123 Jones", "497 Jones", etc. to appear in my query. Is it possible to do this?

This is my code. Only thing missing is more of the same basic if statements.

ElseIf sA <> "" Then

qry = "Address"

DoCmd.OpenQuery qry