I wanted to do a select on

strSQL = "SELECT * FROM Info WHERE Name = '" & userid & "'"(This code work fine)
which display only all the Name = to userid.


But how to combine this
strSQL = "SELECT * FROM Info WHERE Name = '" & userid & "'"


with this

strSQL = "SELECT * FROM Info WHERE INSTR(Info.Name,'" & strSearch & "')"

so i can search the database within the Name = userid only