I am working with an access application, in which my subform is displayed using a recordsource. The user can make modifications to a specific record by selecting a record and pressing the modify button, which opens another form. Once the user completes their modifications, the subform is requeried which causes the cursor to be repositioned to the first record.
What I would like to do is, once the user completes their modifications and the form closes and subform is requery, to reposition the cursor to the record above (previous) the one selected (Modified). Is there a way of doing this??? Does anyone have any idea???
Thanks
Legs
What I would like to do is, once the user completes their modifications and the form closes and subform is requery, to reposition the cursor to the record above (previous) the one selected (Modified). Is there a way of doing this??? Does anyone have any idea???
Thanks
Legs