SOLVED access: put result of existing query in recordset

what is the easiest way to put the result of an existing query (qryOutbox) in a ADODB recordset?

thus, i have created a query in access, saved it with the name 'qryOutbox' and now i want to use this in VBA.

how can i put the result in the recordset, so that i can change values from certain fields?

thanks.

Code:

---

Select qryOutbox.* from qryOutbox

---

Put that as the source when opening your recordset in ado (remember adCmdText as the last option when opening.


Vince