Filtering Macro question?

[mgtyper]

If I have column headings named
Wire
Walker Conn #
Base Sensor

Only the first DoCmd works ("wire =wires")

I get an error on the other two.
I have tried different syntax and have not been able to get it to work.

Public Sub SampleSearch()
 
DoCmd.ShowAllRecords
 
DoCmd.ApplyFilter , "wire = wires"
 
DoCmd.ApplyFilter , "Walker Conn #  = ConnNum"
 
DoCmd.ApplyFilter , "Base Sensor = BaseSensor"
 
 
End Sub