updating MS Access using ADO

[Poloboy]

Hi,
Can someone show how this work. I have
rs.fields(2)= rs.fields(2) - 1 this works fine but if I do the other way around it won't update the record rs.fields(2)
rs.fields(2) = rs.fields(2) + 1 <-this won't update the fields.

Thank you!

 

[Golom]

Is the field to which rs.Fields(2) refers perchance a unique field? If it is then
[tt]
rs.fields(2)= rs.fields(2) - 1
Old Value New Value
1 0
2 1
3 2
[/tt]
No problem

But
[tt]
rs.fields(2)= rs.fields(2) + 1
Old Value New Value
1 2 [red]<-- Duplicate value[/red]
2 [red]<--- There's already a 2 in the table[/red]
3
[/tt]

 

[Poloboy]

There are no unique key for the field.

 

[Golom]

Do you get any errors when you do this or is the field value just not changing?