Change the recordset [Archive]

Click to See Complete Forum and Search --> : Change the recordset

Nov 24th, 2000, 05:16 PM

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

TIA

honeybee

Nov 24th, 2000, 11:17 PM

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

sanon

Nov 25th, 2000, 01:28 AM

Use recordset Requery property to update the recordset.