Hi Craig,
I placed "response.Write(rsCatSearchGW_cmd.CommandText)" after Line 82, which caused the infamous Red Exclamation Point beside any dynamic text referrencing the recordset, but still displayed the information that we were after on the results page.
SELECT * FROM qry_Products WHERE ProductTypeName = 'Glassware' AND ProductDisc = 0 ORDER BY ProductID
I'm still trying to figure out how the information from the search page (keyword, part no., etc.) becomes part of the SQL Statement for filtering on the results page? It's a little confusing to me.
I'm used to passing a variable from the previous page to the recordset for the filtering criteria, but there are no variables defined in the recordset to 'grab'. Can someone explain this to me?
Thanks once again.
Brad