In the following construct, how does one specify that the value in colmun8 comes from the active row of the grid?

FOR i = 1 TO _screen.formcount
IF UPPER(ALLTRIM(_screen.forms[i].name))='WRK2'
_myvalue = ALLTRIM(UPPER(thisform.grdResult.Column8.text1.value))
ENDIF
ENDFOR

As grdResult may contain multiple rows, I need to have _myvalue come from the activerow. Currently I am getting the last row's value.

Any help appreciated.

Andrew