I had LIKE conditions in the recordset and took them out.
ALso i had one text field searching 2 columns (First and Last names) and couldn't get that to work right so i added another text field to search first name only and the other field searches last name only.
I changed text fields to select menus populated from the DB for the Bike tours and tent Products.
Now everything works perfectly.
Thanks for the assist!