Using LIKE in a SQL Query String In VBA

[mckitlk]

Hello, everyone,

I was wondering if anyone could help with this...

BACKGROUND: Present the user with an InputBox to get a search string
that can then be used to search on the current field. I got it working
with the "=" operator. Then I decided I wanted to allow wildcards for
the First Name and Last Name fields, using the LIKE operator. I can't
seem to get the willdcards to work.

CODE:

 

[Douglas J. Steele]

For ADO, the wild card character is % not *. (It's also _, not ?)

 

[mckitlk]

Thanks! this seems to work perfectly now.