Ever used Action queries?
I dont know enough about your problem, however a query can be compiled in VBA to delete a specific record or records based on criteria you select.
Or, if you just want to delete the current record visible then:
DoCmd.RunCommand acCmdDeleteRecord
in VBA behind the...