I am getting the error 'Error - Could not refresh row. Query for primary key '[primary key]' returned no data.' when I save in my list. Now I know why I am getting the error message, but I don't want it to error just to save and then refresh the list.

Basically my list is running off a query with a Where clause that only pulls records of a certain status (LIVE and IDLE). When I change the record to be a status that the query is not pulling (CANCELLED or CONFIRMED) it obviously then removes the record from the list (which is what I want it to do). So the code is then attempting to find it again so it can select it in the list. Hence the error. What I need it to do is remove the record from the list and refresh the grid selecting the next record in the row. How do I do this?

Many Thanks