>I've tried to do this calculation in the lostfocus (and valid) event of colum2.
>When I change rows the first time, with colum2 in row1 as the active cel, the calculation is correct.
>When I change rows again the calculation is incorrect. The column1.text1.value for this row holds the value of
>the previous row.
>
>How do i make sure column1.text1 contains the correct value
>(the value of column1.text of the row in which the lostfocus event of column2.text1 takes place.)
>
>many thanks
Victor,
FWIW do not bother with .Value and directly use tablename.fieldname in your calculation.
Cetin