Quote Originally Posted by MartinLiss
I believe that in VB you need to use the % character rather than the * with Like.
oh, jeez. I was reading through these forums the other day, and someone said it was * for Access (while % is for MySQL, which is why I was doing it like this). But, anyway.. thanks! it works fine now.. I knew I couldn't have been doing much wrong.

edit: thanks to you too, Rhino. I'll give you a rating as well, just because I'm glad I can finish my project now @_@