>Edward, thanks for your quick response. I used skip command in the navigation toolbar and checked for EOF and BOF condition before I called the form refresh method. I used a custom form refreshform method which is:
>thisform.lockscreen=.t.
>thisform.refresh
>thisform.lock screen=.f.
>To verify the problem, I put in something like this in the form refreshform method:
>thisform.lockscreen=.t.
>=messagebox("record no="+str(recno(),3))
>thisform.refresh
>=messagebox("record no="+str(recno(),3))
>thisform.lock screen=.f.
>The first message box shows the correct record no it is supposed to skip into.
>The second message box shows record count plus +1 which indicates the EOF. And I did not put in any code in any of the refresh methods.
>It just seems to be very weird the way it behaves. Without changing any code, the problem may disappear next time you run it.
Do you have any temp relationships?
Edward Pikman
Independent Consultant