If your recordset object is RS:
To update/change a value in the recordset:

RS.Fields("MYFIELD").VALUE = your Value ' ensure value is the same as the
underlying type

To update the source:

RS.Update

For this to work, 1. you need to have opened the recordset with the
'correct' cursor 2. the data source must support Update (or UpdataBatch);
some data sources (like Excel) do not support this functionality.

"OverAC" wrote:


Dears,
I was so confused when reading documents about updating record in the
recordset using ADO. So please help me.
How can I change a record in the recordset and update it to the source
data.
Thanks so much for your help.
OverAC


--
OverAC
------------------------------------------------------------------------
OverAC's Profile: http://www.excelforum.com/member.php...o&userid=32396
View this thread: http://www.excelforum.com/showthread...hreadid=529527