Hi
I have a form that contains a subform, which displays rows of records according to criterias chosen. Now this subform has a select statement in its recordsource.
By default the cursor goes to the first record in that recordset. I must choose the record I would like to delete and press the delete button. The problem I am having is that I would like to reposition the cursor to the record before(previous) to the one that has been deleted.
I tried inserting various codes, like Docmd.gotorecord. It worked but I had to open my subform and everything was done to that subform alone and not to the main form (where the subform is).
Can anyone help me figure this out!!!
If there is no way of doing this, please let me know!!!!!!
Legs
I have a form that contains a subform, which displays rows of records according to criterias chosen. Now this subform has a select statement in its recordsource.
By default the cursor goes to the first record in that recordset. I must choose the record I would like to delete and press the delete button. The problem I am having is that I would like to reposition the cursor to the record before(previous) to the one that has been deleted.
I tried inserting various codes, like Docmd.gotorecord. It worked but I had to open my subform and everything was done to that subform alone and not to the main form (where the subform is).
Can anyone help me figure this out!!!
If there is no way of doing this, please let me know!!!!!!
Legs
