filter query wildcards won't work-pls hlp

[dajabo]

I'd be grateful if someone could offer some help with this to a frustrated Access novice : )

I have a query that filters records according to the value of an unbound text box in my form (basically search on last name)

I want to introduce wildcards into the filtering process but cannot get it to work.

Here's what I've done:

In the criteria field I had
[Forms]![MAIN]![Text440]
refering to the unbound text box on the form already mentioned.

This worked fine, but the following:
Like "*[Forms]![MAIN]![Text440]*" does not.

Nor does various combinations of brackets such as:
Like "*([Forms]![MAIN]![Text440])*"

In fact it now doesn't return anything, even if given a positive match. I have trawled help and the forums but to no avail. I have also tried the % character instead of *

I am using Access2000...

 

[pdx_man]

Because you have it with the quotes, it is looking for the literal text:
[Forms]![MAIN]![Text440]

not the reference to the form.

Try:

Like "*" & [Forms]![MAIN]![Text440] & "*"

 

[dajabo]

Because you have it with the quotes, it is looking for the literal text:

Of course! Thanks VM ...