determine which records are being displayed

Here's the situation:

I have a subform that displays a datasheet view of tbl_table, ordered by
lastname. There is enough room in the subform for 10 records to be displayed
at any given time, with a scrollbar for moving up and down in the table.

When a user highlights a record that he or she wants to delete (which can be
anywhere in the listing of 10), and clicks on btn_delete, the record is
deleted. However, in order to make the deletion complete (and get rid of the
#deleted text), the form has to be requeried. That, unfortunately, resets
the form such that the first ten records are displayed instead of whatever
the user was looking at when he hit the button.

What I want is to remove the record being deleted without going back to the
top of the list. It seems to me that, if I could determine which records are
being displayed before delete, I could add a go to record command after the
requery and return to whatever record was at the top of the group being
displayed before the delete button was clicked.

I'm sure this must be a pretty simple thing to do, but I'm not able to find
out how by looking through other threads..

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200905/1