Karl

Thanks for your reply.
I'm sorry. I wrote the instruction wrong. It must be:
Like [Forms].[Form].[txtWords]&"*"
Nevertheless, as you suggested I tested again:

Like "*" & [Forms].[Form].[txtWords] &"*" .
If I enter one word it works but If I enter two words separated by space,
query shows nothing. I don't know why.

Any idea is welcome


"KARL DEWEY" wrote:

I would suggest separating by space and using this --
Like "*" & [Froms].[Form].txtWords] &"*"

Remember that when you type in 'bell' you will also get 'bellows' in the
results.

--
Build a little, test a little.


"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