>>>>Is there a way to find which record shows in the first row of a grid? RECNO() would be fine.
>>>>
>>>>TIA,
>>>>
>>>>Alex
>>>
>>>It depends of the current ORDER.
>>>Maybe the MIN() value of the order KEY?
>>>or even:
>>>
>>>SELECT GridRecordSource
>>>GO TOP
>>>lnTOPRecNo = RECNO()
>>>
>>>
>>>but you should change it everywhere you change the current order of that table.
>>
>>Thank you for the response Borislav.
>>
>>That doesn't return the number of the record that *appears* at the top of the grid. It doesn't necesarily mean the first record on the table order, but the first one that is visible at the top of the grid. What I need is similar to grd.LeftColumn, but for rows.
>>
>>Thanks,
>>
>>Alex
>
>Something like this should work, not tested:
>lnRecord = recno()
>skip -(yourgrid.relativerow-1)
>lnTopRecord = recno()
>goto lnRecord
I'm working what you and Bosrislav suggest, though I don;t like the idea of skipping back and forth. Probably better to select into an array all recno() ad work from the array.
Thanks