“type key word here” search

[whitestone]

I have a database which lists various statistics that my organisation holds. When we get a new statistic in I want an easy way for people to check it off against the current list to see if a similar/matching one exists.

What I would like is for a form to come up saying “type key word here” with a blank field where they can type in a word and Access will search the table for the key word in a number of fields. How can I do this?

I am used to liking simple macros to buttons etc. in forms that will open a query etc but connot take it to another level. I can’t work out how to enable the text typed into a boc to be populated into a query in criteria like this --> “*text*” under a specified field.

I have attached a sample database that could be used to explain this to me. In the sample I would like the search to be done on the ‘Indicator’ and ‘KeyWord’ fields in ‘TestTable’. I am sorry but I can’t post the actual table due to confidentiality.

Many Thanks

 

[adevera]

All you have to do is create a text box for the word to search for.

And then create a Procecure that will look for such as SQL statement...

 

[whitestone]

Thank you for your reply.

Would it be possible for you to go into a little more detail about what I would actually have to do. You mention a procedure but I am unsure what you mean by this.

Thanks