sebastico wrote:
In Access 2003.
In a form I have a parameter to search for a word at a a time
Like [Froms].[Form].txtWords]&"*" which works well.
.
In order to enter more than two oarameter separated by commas in txtwords I
have been tryin the Str function like this
"Instr([txtWords])"
"Instr[txtWords]"

The query displays no records at all.

Could you suggest me how to do it

Many thanks

You wouldn't be able to do this directly if you want to search for multiple
words
You could use SPLIT to break out the separate words (and maybe use TRIM to
cut off the leading and trailing space). Then you would have to loop through
the array and AND them to the filter. Not trivial, but doable.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1