hard coded conditions like this should be added in the Data Assist search, they should be added in the recordset where clause:
WHERE (ProductDeactivate = 0) AND (ProductExclusiveFire = 0 OR ProductExclusiveFire = 2) AND (ProductExclusiveFire <> 1) AND (ProductExclusiveBM <> 1) AND (ProductDeactivate <> 1)