Access table update

[Per_]

Hello all,

I would like to update a table with the code below. Do I need to open with different attributes to get it to work?

Please help!!

/P

Dim RecordSet As ADODB.RecordSet

 Set RecordSet = New ADODB.RecordSet
 RecordSet.CursorLocation = adUseClient
        RecordSet.Open "Select Test1, Test2 from Table WHERE ID = '" & ID & "& "'", Connection, _
                 adOpenDynamic, adLockBatchOptimistic
 RecordSet.MoveFirst

RecordSet.Fields(0).Value = "TEST"   <---- Why can I not update like this? Do I need to open with different attributes?

 Set RecordSet.ActiveConnection = Connection  
 RecordSet.UpdateBatch
 RecordSet.Close
 Set RecordSet.ActiveConnection = Nothing

 

[ranman256]

Try:
Rst.edit
Rst.fields(0).value = "bob"
Rst.update

 

[Micron]

& ID & "& "'", Connection, _

You have the last ampersand in the wrong place and it's causing the rest of the line to be commented out, which is why it's green.
WHERE ID = '" & ID & "'". Connection, _ ....

Surely that raised an error that you didn't report?