DataGrid + Delete a record

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

With Data1.recordset
.edit
.delete
.update
.movelast
End with

I hope this helps