Query fields and terms

[john mcmichael]

I have an Infopath 2003 form connected to a Access 2003 DB. It all seems to
work fairly well so far. I currently use the query option on the form to
search a field that holds a key word. I would like to add more than 1 key
word for many of my enrties so that if any of the key words are typed into
the query, results will appear. Right now, it seems I can only have one key
word

 

[S.Y.M. Wong-A-Ton]

Correct. That's the built-in functionality of InfoPath. Multi-keyword search
is not possible without writing code. Doing a wildcard search has been
discussed before in this newsgroup, so you should be able to find code sample
online of how to add a WHERE-clause to the SQL statement of your form to
enable your wildcard-search scenario. Also have a look at this article:
http://support.microsoft.com/?id=826992