I have a program that looks up data in an access database using an ado recordset in visual studio 2005. my problem is that i wanted to be able to enter something into a text box and select only records that CONTAIN what ever is in the text box. i've tried the following:

"select * from myQuery where (field like *'" & textBox.text & "'*);"

which works with an access query but when i've used the exact same statement in a recordset.open command it doesn't find any records. does anyone know why this is happening or another way of searching records?