>Have needed many time to "hold_recno = recno()", do something, then "go hold_recno". This does not work if recno was eof or bof. What is a good way to save the record pointers position, and then return exactly there, whether it is a good recno, bof or eof.
>
>Thanks - Brenda
Hi Brenda,
You can use this way to return the record pointer to exact position of a file:
-----------------
Hold_RecNo = IIF( BOF(), 0, IIF( EOF(), -1, RecNo()))
...Do something...
Do Case
Case Hold_RecNo = 0
Go Top
If !BOF()
Skip -1
EndIf
Case Hold_RecNo = -1
Go Bottom
If !EOF()
Skip 1
EndIf
Otherwise
Go Hold_RecNo
EndCase
----------------
Alex
Alex