Form Update

[Asif]

Hi All

I have a fom (frm_cable) which displays a listbox showing id, date and
quantity. If I want to delete an entry a new form opens where I have
to select the user who is carrying out the transaction and they fill
in a comment (why did they delete it) once I save this delete record I
want the id in frm_cable to increment by 1, when i come back to
frm_cable so that i can enter new data.

I've tried creating a command button with the following code in
frm_cable to increment before i carry out the deletion process

DoCmd.GoToRecord , , acNewRec'
'Me.PPROCESSID = Nz(DMax("[PROCESSID]", "tbl_PROCESS")) + 1

but if i do that then the deletion form does not pick up the correct
entry to delete hence I would like to apply this form after I've saved
the deleted record

Any suggestions would be appreciated

Thanks