I'd start by looking at your resulting query to determine what exactly is wrong. DataAssist Search updates the recordset where clause. If it returns the wrong results it must be building the where clause wrong... I would start by looking at it and seeing what was wrong with it.