Using ADODC1 Control in VB6

Guys,

I wants to add a ADODC1 Control to my form and Assign the Connection and Recordset Property throught Coding.

After that i wants to Assign that Current Record set to One more new Recordset. So that i can populate that record in some fileds. (please not i dont wants to assign that directly to the controls thro ADODC control. becase using the values i need to get some more records for that).

Each click in ADODC1 movenext or movelast.... i need that values in TEMP RECORDSET.
So that i can using that Temp recordset i can do the next steps.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

please note this
***********************************************************************************************
After that i wants to Assign that Current Record set to One more new Recordset. So that i can populate that record in some fileds. (please not i dont wants to assign that directly to the controls thro ADODC control. becase using the values i need to get some more records for that).

"Each click in ADODC1 movenext or movelast.... i need that values in TEMP RECORDSET.
So that i can using that Temp recordset i can do the next steps."

I don't mind, but I would like to get my two cents in on this one. If it didn't work, then let me know, and I can propose new or different techniques to solve your problem. Abandoned questions get on my nerves, when I discover that someone didn't give me a chance to help.