search in a field, only searches the first word :(

[nkour]

in my db: www.greekarena.com/nkour/Biblia_2004-01-27.rar


I have a main problem.
it should contain books.
let's say I enter a record with Title "introduction to Computing"

when I go to serach for it, and type "Computing" it doesn't show it!

I should type "introduction" or "introduction to Computing"

in my Query i have

this

Like [Forms]![search]![withtitle] & "*"

but this only works if title has the first word. thanks in advanc

 

[Allen Browne]

To find a word anywhere in the field, you need a wildcard at the start as
well as the end:
Like "*" & [Forms]![search]![withtitle] & "*"