Hi Everyone,

I've been stuck again for ages but just can't this to work and hoping someone could help me again.

I know the general rule with deleting records and why it's not advised but as some may know I'm building a database for me to hold lock and information. If the lock gets replaced or changed there is no need to hold the records or key count anymore so I would like to have a button on the edit cylinder form (AdminCylinderEditF) that will allow me to delete the record.

I have a customer form (AdminCustomerResF) with a subform that holds the cylinder details (SubFormAdminCylinderRES). From the subform, I have a button that loads an edit Cylinder details form (AdminCylinderEditF). Then on that form, I have a delete button that is visible when in edit mode.
When you press the delete button, after the form closes the record is deleted but I can't get the subform to requery and the deleted record still shows until I leave the current record and then come back.

If I use that button and VBA code on the Subform rather than the edit cylinder form it works fine with an afterupdate me.requery code.

My only issue with this is that it is very easy to delete the wrong record with the record selector and a list. I think I really need to have a form you have to load, then press edit, then delete. I feel this is a safer option.

My delete VBA is
If MsgBox("Are You Sure You Want To Permatley DELETE Cylinder", vbYesNoCancel) <> vbYes Then Exit Sub
    
    On Error Resume Next
    CurrentDb.Execute "DELETE FROM CylinderT WHERE CylinderID=" & CylinderID
    DoCmd.Close

Any help or a nudge in the right direction would be greatly received.

Thanks Gary