Query search question

[bigguy]

I have the following code in my query [Forms]![ProjectSiteFrm]![NpiIDtxt]
where NPIIDtxt is a textbox on a form. What I would like to have is when user enters
data in text box it will find any records with those variables.

The problem I'm having is users are not always entering the full string in the textbox so when they do a search it
will give them a no records found. How would I change that so that any record which contains any of the values in the text box is returned

[June7]

Use LIKE operator and wildcard.

LIKE "*" & [Forms]![ProjectSiteFrm]![NpiIDtxt] & "*"

You say plural 'values' - what do you mean?

[bigguy]

Don't mean to say plurals. I tried the above code but no results are dispalyed and I know there are records in the database with at least some of the criteria

[June7]

It is a proven technique. Post the complete SQL statement.

If you want to provide your db for analysis, follow instructions at bottom of my post.

[orange]

bigguy,
Watch this free youtube video. It will show you some techniques re search and text box.