I have a form with two grids, grid1- parent employee file,
grid2- child activity file.

I have a textbox to hold the sum of activity.hours, but it seems to just display the final record value, not the sum. Here's the code I have in RowChange of Grid1:

gcSeekVal = employeeno
calculate sum(activity.hours) to thisform._textbox1.value for activity.employeeno=gcSeekVal
seek gcSeekVal &&this is just to keep pointer on employee clicked

What obvious thing have I missed. (Tick, tick, tick, Y2K clock)

Thanks in Advance,
Sylvia