>Hi Nadya,
>
>> this record should disappear from the view (since it's manually resolved) and user should automatically go to the next record in a filtered view. I can not achieve this functionality. I always skip one more record, than needed.
>
>I am guessing here, but all you should need to do is:
>
>SELECT < viewname >
>DELETE
>< Grid >.SetFocus()
>
>If that doesn't work then, obviously, we need to dig a little deeper and see what's happening.
We're not using views here (for my regret), we're using tables directly. I change work field from '5' - Suspect to '6' - Manual Resolved. So, this record should disappear from filtered view.
Anyway, the problem is solved by minor alteration of the original code.
If it's not broken, fix it until it is.
My Blog