Search Engine in Access

[Guest]

Hey Guys,

I'd like to build a type of "search engine" in one form on Access. I have a
table that holds general questions and answers about products. I'd like to
be able to type either a question or a word or several words such as you can
with "Google" and come up with a list of possible answers to those questions
based on the Question/Answer table. I've tried something using the Like
operator in an underlying query, but it is not adequate. Any suggestions?

 

[Ken Snell \(MVP\)]

Perhaps my sample database showing how you can build a search query based on
selections/entries in various controls on a form will help:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[Guest]

Ken,

Thanks for sending me the links to your sample databases. The one with the
buttons on the combination form is the most like what I am trying to do. It
gives me some ideas on how I can revamp.

I appreciate your help.

--
Lisa

Perhaps my sample database showing how you can build a search query based on
selections/entries in various controls on a form will help:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm