>Hello all
>I have a grid with recordsource = cursour
>When will be the best time to do the calculation?
>eg duration = time1 - time2
>I tried the on lost focus of time1 & time 2 and it works but i get the calaculated column repeating
>on the next line(s) when a move down with the arrow key.
>Any help?
>thanks in advance.
Sammy,
Sounds like duration is a memvar. If your table/cursor has fields Time1,Time2 then just having another column with controlsource 'myTable.Time1-myTable.Time2' is sufficient.
Cetin