You need to put it in your procedure file, or have it as standalone procedure in .prg file

Into AfterRowColChange you just put the call to this function/procedure

mytextbox.value = sum_activity_hours(employeeno)

Nick


>Hi Nick,
>Thanks for the suggestion. I am new to some of this. Where do you insert such code? I tried it in the AfterRowColChange of Grid1 and got an error "Methods or events cannot contain nested procedures or class definitions."
>
>Pardon stupid question. (Would that be PSQ?)
>
>Thanks again,
>Sylvia
>
>
>>Silvia, I usually use the functions like this one for getting the sums:
>>
>>FUNCTION sum_activity_hours
>>LPARAMETER lcEmployeeno
>>LOCAL laSum[1]
>>store 0 to laSum[1]
>>SELECT SUM(activity.hours) FROM activity ;
>>WHERE activity.employeeno = lcEmployeeno ;
>>INTO array laSum
>>RETURN laSum[1]
>>ENDFUNC
>>
>>HTH,
>>
>>Nick