Filter fields including records with null

[Ruegen]

deleted

UPDATE: sorted

[June7]

You aren't handling the Null field.

StrName = IIf(IsNull(Me.txtSchoolS), "", " and Nz([SchoolName],'') Like ""*" & Me.txtSchoolS & "*""")

[Ruegen]

You aren't handling the Null field.

StrName = IIf(IsNull(Me.txtSchoolS), "", " and Nz([SchoolName],'') Like ""*" & Me.txtSchoolS & "*""")

Clearing everything and using Allan's method - see if that will work for this particular form

other form using his method works great.

[Ruegen]

Sorted - Allan's method works great (and a smidge faster too)

Thanks June for your help (and everyone else)

...now to build in error traps... sigh