>I have a from with a grid on it. The grid has 3 columns. When the user dbl-clicks on the third column, they can pick a value from a popup window. The grid may have from 1 to n number of rows. After they double click and pick a value, I need to build a string of all the values in the 3rd column of the grid. Is there a way in code to walk the grid get the value column 3 in each row? I know how to get the value from the cell, but I don't know how to walk the rows?
>
>
>lcString=[|]
>for x=1 to reccount("Meetings")
> lcString=lcString+thisform.grid1.rowx.column3.value
>endfor
>
You have to scan underlaying table (cursor), e.g.
select (this.RecordSource)
lcString =''
scan
lcString = lcString + evaluate(this.Column3.controlsource)
endscan
Though it would be better to use myTable.myField instead of evaluate()
If it's not broken, fix it until it is.
My Blog