Queries on the fly

[smith.stuart]

Is it possible to create queries on the fly, i.e. I am creating a database that is to search for a word in a field (field contains a sentence) but that word could be absolutely anything. How do I create a query that is generic but contains that word as and when it is entered into say a search (text) box?

 

[Rich]

http://support.microsoft.com/default.aspx?scid=kb;en-us;210242