a little confussed
I don't understand what you mean by " Use the interface"................ I understand this part " 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" and I"m not sure what you mean by
"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.
In the record set I see where to change the parama to contains,????