I have adapted Allen's search to a company database which greatly improved the search function. The search is currently pulling records from 'tbl_property' and I have been asked to include the client name in the search criteria. The client information is in 'tbl_trans_buyerseller' and is linked with 'TransID' field. I have tried using a query as the record source with no success. Much too slow. Is there a method of adding a 2nd table to this search function? FYI - BE is SQL2000 and FE (Access 2000) resides on Terminal servers using runtime. Any help would be greatly appreciated.