Are the two tables related? I'd probably use two different recordsets. Then each recordset can filter with the same text field.
The here clause would have the column and parameter repeated for each column you were searching against.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.