2 things:
1) edit the data assist search server behavior, and remove the conditions for the ProductExclusiveFire, ProductExclusiveBM, and ProductDeactivate columns that where added to the recordset SQL
2) you have 5 criteria all set to use the S_ProductName form element, instead of using 5 criteria, use 1 and set it to be a key word, using a key word criteria type, you can select multiple columns to filter in the column list