>thisform.text1.Value=mycur.field1 && Replace field1 with the name of the field >thisform.text3.Value=mycur.field11 && Replace field11 with the name of the field >thisform.text4.Value=mycur.field4 && Replace field4 with the name of the field >>
>>SET DELETED on >>SELECT TAlias1.employeeid,TAlias2.nam,TAlias2.nam4,TAlias1.workdays,TAlias1.absencewp,TAlias1.absencew,TAlias1.uovertimeh,TAlias1.whovertime,TAlias1.vacations,TAlias1.sickvacati,TAlias2.wark ; >> FROM payroll TAlias1, mstr TAlias2 ; >> WHERE TAlias1.employeeid = TAlias2.no ; >> ORDER BY employeeid ; >> INTO cursor mycur readwrite >> >>COUNT TO thisform.text2.value >> >> thisform.Grid1.RecordSource=" mycur" >> thisform.Grid1.refresh() >>>>**at thisform.Grid1 event afterrowcolchange&&
>>>>**afterrowcolchange >>>>thisform.text1.Value=thisform.grid1.column1.text1.value >>>>thisform.text3.Value=thisform.grid1.column11.text1.value >>>>thisform.text4.Value=thisform.grid1.column4.text1.value >>>>>>>>thanks