In my database, I have a Troubleshooting table that contains frequently asked questions and their corresponding answers.

What I've been asked to create is a search form where the user can type in part of a question, a keyword, or a phrase and all the questions in the Troubleshooting table that contain that bit of text will come up. The user can then double click on the question they want and the answer will come up.

I can handle the double click code. I don't know how to create a search that will look at parts of the text.

Anyone have any ideas?

Crystal