Auto-Compute on cells of Datasheet

[keirnus]

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)

 

[wiklendt]

there have been a few threads on this topic in the past. mainly to do with accounting. try searching the forum.

good luck with your project.

 

[Galaxiom]

I suggested last week to someone with a similar request to search the forum for "running total". They replied that they had found what they wanted.