Code:
If rs31![POID] = rs32![POID] And rs31![MRP Date] < rs32![Pstg Date] Then rs31.Edit rs31![QTY ACC] = rs32![QTY ACC] rs31.Update
Any help on that pls?
Edu Castro
Last Activity: May 12 '11, 12:56 AM
Joined: May 7 '11
Location:
-
Edu Castro started a topic How can I add up a value to the current recordset value when editing a table?in AccessHow can I add up a value to the current recordset value when editing a table?
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
In other words I need rs31 to be equal rs32 + current value in rs31.
Any help on that pls?Last edited by NeoPa; May 10 '11, 11:22 AM. Reason: Added CODE tags for you. Please remember for next time.
No activity results to display