cannot use * in ado record sets

[Alsvha]

Been ages since I've messed around with access, but shouldn't the ' be on the other side of the *?

Like this:

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