Using the criteria you list, if Text10 is blank, then the criteria is
This will return all records. Instead try:
Like (IIf(IsNull([Forms]![StreetLookup]![Text10]), Null, "*" &
([Forms]![StreetLookup]![text10]) & "*"))
If you have Null values in this field, then those records will still be
returned. If so, replacing Null with "" may do what you need.
MS Access MVP