I am trying to do some calculations in a grid.
I am using it a little like a spreadsheet.

However I notice that as I move around my grid the Grid.Activerow
and the grid.relativerow always appear to read zero.

I need these poperties to work because I am hoping to use the Activatecell(nrow,nCol) method and it will need the right co-ordinates to work.

I have been forced into trying to do it this way because I tried doing my calculations on the underlying table but could not get my grid to refresh with the new data, so if someone knows how I can get the grid to refresh. (grid.refresh does not work) then I may be saved having to sort out the above problem.


Many Thanks