Query based on text box from a form

[LonghronJ]

I have a form that has a text box which a user can fill to filter the form. If the text box is left empty, I would like to show all the records. If the text box is filled with a word/phrase, I'd like the result to show records containing the word or phrase in the text box. My criteria in the query is

Like "*" & [forms]![myForm]![myTextbox] & "*"

I have used this expression in many queries and it seems to work. However, this particular query is not returning any records that have empty/null when the user does not fill in a value in the text box. Any ideas?

[June7]

But you don't want the Null records if parameter is input?

Need to handle the Null. Construct a field in query with expression:

Nz([fieldname], "None")

or

IIf([fieldname] Is Null, "None", [fieldname])

Review http://allenbrowne.com/QueryPerfIssue.html

Apply your criteria to that field.

Or don't use dynamic parameterized query (I NEVER have). Use VBA code to dynamically construct filter string. Review http://allenbrowne.com/ser-62.html