>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
PMFJI,
Eric also posted that the Open method needs a source parameter passed. Try adding something like "Select * From myTable" to the Open line:
rsdata.Open "Select * From myTable", cnActiveConnection