Filter form with parameterized query

[wnicole]

I have also tried this search form from You Tube. It works fine however it doesn't pull up all my records.
I was told I need to add some IsNull code to it.
Would you happen to know how to do that to the criteria?

[June7]

If any fields could have null for any records then two options.

1. use Is Null criteria along with the wildcard

Like "*" & [input value] & "*" Or Is Null

2. Handle the null with an expression that calculates a field in query like:
Mid: Nz([MiddleName],"")
and apply the wildcard criteria to that constructed field.

[wnicole]

Ok I will try the or is null today and let you know ...I have reAd thread they that doesn't work but not sure.


So question... I would do " or is null on each columns after wildcard on same row correct? Or do I put it on the row that say "OR ?

[June7]

I think either way should produce the same SQL statement. Try them and let me know.