Neil
When you delete a rec, and want to go to the next, it's a bit more complicated than this but, essentially:
IF Not EOF()
SKIP 1
ENDIF
IF EOF() AND Not BOF()
SKIP -1
ENDIF
When you create a new record, have you ensured that you've APPEND BLANK, or recalled an existing record that's marked for deletion? It's not enough to just focus on the now-enabled text boxes of the fields.
Terry
>I have a grid with six columns each bound to fields in a table. I also have the same six fields on my form with my grid which are bound to the table also. Therefore when I select a record in the grid the values from the table are shown in the fields on my form. This way I can quickly edit, replace etc. When I delete a record I want the grid to focus on the next record in the list after the record I have just deleted? Also when I click on my new button which enables the six fields nothing happens, is this because the fields are bound to the table, at runtime they are disabled?
>
>Any help would be appreciated. Many Thanks
- 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.