Hello,
I got something interesting which I hope it really exist.
If the title isn't understandable enough, I will explain further.
I have a SubForm in Datasheet view.
I set SubForm's Control Source with a SQL query in order to display a table of data.
Example:
Same as the automation in Excel, I want something to be implemented in Access.
Everytime a data in a single cell is changed (input/edit/delete) at runtime in Value column,
the data in Accumulating column will also change.
I tried setting the Control Source of the Accumulating textbox only and it works for a "single row".
Example:
Control Source =[txtValue]+1
But since it says "Accumulating", I wanna add the current Value data with the previous Accumulating data.
Like the one below:
I don't know yet how to set the Control Source.
This is where I am stuck.
How to get the row source of the previous record?
Or....is there a better way to mimic the automation in Excel?
(just accumulating the data by adding the current value with the previous value...just like in Excel but implemented in SubForm Datasheet view)