How can I add up a value to the current recordset value when editing a table?

[Edu Castro]

here is my code I can edit the current rs value, but this code is replacing the existing one. Instead I need the code to add a new value to the existing one

If rs31![POID] = rs32![POID] And rs31![MRP Date] < rs32![Pstg Date] Then
rs31.Edit
rs31![QTY ACC] = rs32![QTY ACC]
rs31.Update

In other words I need rs31 to be equal rs32 + current value in rs31.

Any help on that pls?

[gnawoncents]

If I understand you correctly, if rs31![QTY ACC] is 5 and rs32![QTY ACC] is 6, then you want rs31![QTY ACC] to be 11, right? If so, try:

If rs31![POID] = rs32![POID] And rs31![MRP Date] < rs32![Pstg Date] Then
rs31.Edit
rs31![QTY ACC] = rs31![QTY ACC] + rs32![QTY ACC]
rs31.Update