the way data assist search works is to dynamicly create the where cluase to filter the recordset, and append it to the recordset select statement before it is executed.
One strange anomaly I see in the code, is that the price form elements are being referanced using the generic Request collection, but the keyword element is being referanced using the Request.Form collection. For example, line 16 - 18:
WADbSearch1.keywordComparison(KeyArr0,"" + String(Request.Form("tfKeyword")) + "","AND","Includes",",%20","%20","%22","%22",0);
WADbSearch1.addComparison("ProductRetPrice","" + String(WADS_stripCurrency(Request("tfMinPrice"))) + "","AND",">=",1);
WADbSearch1.addComparison("ProductRetPrice","" + String(WADS_stripCurrency(Request("tfMaxPrice"))) + "","AND","<=",1);
try changing line 16 to:
WADbSearch1.keywordComparison(KeyArr0,"" + String(Request("tfKeyword")) + "","AND","Includes",",%20","%20","%22","%22",0);
if that does the trick, you'll also want to change line 52:
WADbSearch1.keywordComparison(KeyArr0,"" + String(Request.Form("tfKeyword")) + "","","Includes",",%20","%20","%22","%22",0);
to:
WADbSearch1.keywordComparison(KeyArr0,"" + String(Request("tfKeyword")) + "","","Includes",",%20","%20","%22","%22",0);