Use the interface. Your SQL Statement would be something like:
SELECT * FROM tb_supplies WHERE Supplies_id LIKE supParam OR Make LIKE makeParam OR Model LIKE modParam OR Cart_Number LIKE cartParam
Then add the 4 Param values as parameters in the recordset. Then set the Type for the params to "contains" and it will automatically add the necessary code to do a contains search for those params.