help!!!! visual problems when deleting records from a continuous form

[dan]

I have a form which I have specified as continuous. I was
experimenting with deleting records and experienced
strange results.

Basically, I went to the bottom of the form and deleted
the last record. That worked fine.

Then I went to the "new" last record and selected
the "Edit/Delete record". Then when I was asked whether I
really wanted to delete the record or not, I decided to
say no. The result was that all but one of the records in
the list were hidden (they definitely weren't deleted).

I then closed and re-opened the form and all the records
reappeared. I can reproduce the problem at will. I have
tried selecting records in various positions in the list
and what it appears to do is hide the records that are
above the record that you were going to delete. Hence,
when I selected the last record, all but one record
remined on screen.

Can anyone help???

Many thanks,

Dan.

 

[John Vinson]

I have
tried selecting records in various positions in the list
and what it appears to do is hide the records that are
above the record that you were going to delete. Hence,
when I selected the last record, all but one record
remined on screen.

They're there, just scrolled up above the screen, leaving the record
after the deleted record the "current selected record". You can use
the Scrollbar (if you haven't disabled it) to scroll up and see them.

If it's vital that you see the first record (bear in mind that if
there are more records than will fit on the screen you might never be
able to see all the records), Requery the subform in its own
AfterDeleteConfirm event.