Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forms - Setting Value To a Consecitive Row Item

Status
Not open for further replies.

thebull1

Programmer
Oct 24, 2001
68
Further to a problem that has been really troubling me for a few days.... I am modifying an item on a certain row. At post_change I capture, using a select, the previous and consecutive values. I am doing a substraction of the two from the current and would like to set the difference on the difference column on the second row.

My block looks like thus:

....READ_VALUE | DIFERENCE
---------------|---------------
0 | 0
6 | 6
10 | 4
13 | 3

When for example I change the value 10 at row 3 to 11, at the post_change, I am able to set the former difference of 4 on the same row to 5. I also need to reset the value 3 on row 4 to 2 (ie 13-11) to reflect the new difference. That is what I am unable to do. Please assist...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top