Requery of continuous form resets order

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a continuous form and have a button on each line that allows the user
to delete the current record. The deletion is done via a SQL "DELETE"
command.

The issue I have is that when the list might be 100 or so items long ans
when the user deletes the current item, it requeries the form and sends the
focus to the first record. Hence the user must scroll back down to where
they were when tehy deleted the item.

Is there a way to have the form remove the selected item from teh continuous
form and then immediately put the user onto either the previous or next item
(so that they are essentially back to where they were in teh list wehn they
performed the deletion?)

Thank You,

Stephen
 
In the code behind your button, get the value of a unique field of the record you want to
go to after the delete then move to that record after running the delete query.
 
Back
Top