deleted
UPDATE: sorted
deleted
UPDATE: sorted
You aren't handling the Null field.
StrName = IIf(IsNull(Me.txtSchoolS), "", " and Nz([SchoolName],'') Like ""*" & Me.txtSchoolS & "*""")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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