If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|