Please help..

I have used a datagrid to display records from an ADO recordset. What I need to be able to do is delete the currently selected record from the recordset.

I have used the following code to determine the record the user has selected:

DieSelected = datagridBookInDieNew.Columns("Order_ID").CellValue(datagridBookInDieNew.Bookmark)

The selected record is then transferred into another table but I need to be able to delete it from the table it was in..

Any help greatly appreciated