Keyword search engine???

  • Thread starter Thread starter guitarfunk24
  • Start date Start date
G

guitarfunk24

I am trying to make a search engine form for one table of mine
because it has long descriptions for each record and there are 5000
records its kind of hard to use a combo box search. I was wondering
if anyone out there had an example of a keyword search engine so I
could see how to do it because I am at a loss. I already had a
criteria search engine that didn't work well enough for what I need.
I need something that will search out everything that has the word I
type in it and bring it up even if there are more words in the record.
 
I am trying to make a search engine form for one table of mine
because it has long descriptions for each record and there are 5000
records its kind of hard to use a combo box search. I was wondering
if anyone out there had an example of a keyword search engine so I
could see how to do it because I am at a loss. I already had a
criteria search engine that didn't work well enough for what I need.
I need something that will search out everything that has the word I
type in it and bring it up even if there are more words in the record.
Click to expand...


Just use a an unbounf text box in a form's header section to
enter the word you want to look for. Set the form's record
source to a query for the records you want to search and use
this kind of criteria for the description:

Like "*" & Forms!theform.thetextbox "*"
 
Back
Top