To do this with recordset, i think you need to locate the record location first by the FindFirst method then follow by the delete method in you recordset object.