Sub find_make() ' ' find_make Macro ' Macro recorded 10/12/2007 by Joanna Walters ' ' make = Database.TextBox1 make = "=" & make Selection.AutoFilter Field:=2, Criteria1:=make, Operator:=xlAnd End Sub