>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.