>I have recordset that gets changed all the time based on different criteria. So it's not part of DataEnvieronment. How can I link this recordset to Adodc object.

You can retreive a recordset and set the ADODC to this recordset like this:

set adodc1.recordset = YourRecordsetObject