Be sure to use the quotes if you search for string. When I started programmin in VB3 (there was no Internet yet commonly spread) it took me 3 days to figure it out. Wish someone has told me that then:

Code:
SQL = "Select * FROM tblClients WHERE clientID = '" & str(myValue) & "'"