Change the recordset

Hi,
How can i change the recordset without use "close" and "open" the recordset using ADO code???+

TIA

Try changing the command property. I guess you still have to open it again. You cannot do it dynamically.

Use recordset Requery property to update the recordset.