• I doubt it's going to work because you cannot set District to 1 and something else at the same time

    OR ((([Austin Police Department].District) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*" And ([Austin Police Department].District)="1"))