Update Field in Record Set Function

Hi All,

I am using the Record Set function in VBA Excel.
For insert the data into the Access table, I used the below syntac comment :

SetRs3 "Insert Into TableName Value("A","001",1000,False)"

But I want to know, how can I do if I want to change only the field ?
For example I have data : "A", "001", 1000, False
I want to change the last field from False become True

Any body can help me to share the syntac ?

Regards'
AqieqS

It's not something I've ever