>I'm having a tough time with a grid on a form. This form and grid worked fine in VFP 8 but since we moved it to VFP 9 it's not working properly. We have a screen based on an employee table with a grid that has child data in it (transactions).
>
>The transactions in the grid are ordered chronilogically and all that seems to work great. I add a record to the transactions table and no matter what date time I use it appears at the bottom of the grid. So let's say I use some date and time that should land somewhere in the middle of the data (that I would need to scroll up in the grid to find if it were in the right place). If I try to refresh it does nothing, my new record stays at the bottom. If I try to setfocus() on the grid, the grid re-orders correctly but the record pointer is still on the last record and now I have to scroll up to find my new record I just added.
>
>Both employee and transaction tables are VFP 9 tables. I'm wondering if this is a bug in VFP 9?
>
>Thanks,
>Don
How about:
As soon as you've finished creating the new rec, store it's RecNo() in a form prop. Refresh the grid, and/or Setfocus on it and Goto the stored rec #.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.