The % makes no difference. I used the FIND a while back and remember that it worked. As for the string after opening the recordset.. I dont need it because I have the search criteria in a string already and this its being used with the find. I only want to open the recordset and refer it to an active connection.

ie.. rsdata.Open, cnActiveConnection

I seem to get an eror on this line... The error is: Command text is not set
I have never seen this error before.

Thanks for all your help

Alvin