search using forms

  • Thread starter Thread starter edm
  • Start date Start date
E

edm

Im using a form with an unbound text box and an execute
button to perform searches in my database. However, I
have found that I cannot search using the wildcard *
anymore. Instead I must know the exact spelling of my
search. This is a problem because Im using model numbers
from different manufacturers, most of which make no sense
outside of their factory.

Is there a way to enable * functionality in a text box
based search form?

Thanks,

-edm
 
Somewhere in your sql string you need to add the word Like in front of your
unbound text box name and add * after the textbox.
 
Back
Top