Hi,

I have a datagrid, and I have the RecordSource Set to it..

I want to update the selected record.
Once I update it should not appear in the screen (Status = NO).
But the arrow should now point to the record before it.

I should also be able to sort the data. After updation the data should still be sorted..

Please advice.

Thanks,
Pradeep