something I don't get, though - you have one set of fields, then you get the values from those fields, do something to them, store those values in an array and then output the array values to another set of fields? or am I confused?
What I have is a 9x7 array variable that is initialized to zero.
Then, I drop some number into one of the cells.
Then, for each orthagonal cell, I subtract 1, repeating until all cells are filled with the new value. The formula is;
k - (|x-a| + |y - b|) where;
[INDENT]k: the dropped number
a,b: the current array coordinate
x,y: the starting array location[/INDENT]
Once the array is finished, I need to dump the value of each cell into a corresponding text box among the boxes arranged into a table.
In VB6, I'd just have two loops, one to loop through the columns and one to loop through the rows with a counter to increment the index value for the grouped text boxes. Or, there's probably a table field I could use that would reference x, y coordinates. But, anyway, there is a dynamic property of the text boxes (or table) that I can manipulate via code.