Calling One Event in Another Event

[mothi]

Hi, Please this is not a duplicate question. I need to save a delete record. the Purpose is same but the way i should do is different now. So thats why i need your help guys. Whenever a user deletes a record on the form I need to store that record in a separate table.

I was told that i should not create any message prompts and i should use the system prompts( which comes up by default) and i need to grab the record information ONDELETE event and store it in a temporary storage field and address this field in AFTERDELCONFIRM event and save the information in a separate table .
SO ONDELETE = save the information of the deleted record in a temporary field ( or temporary storage)

AFTERDELCONFIRM = address the ONDELETE EVENT and save it in a separate table . GUYS I need your help here please HELP ME OUT.

 

[MStef]

Look at "DemoDelRecAddRecA2000.mdb" (attachment, zip).
Look at Tables, Queries, Form1 (VBA).
Open Form1 and try. Adapt it in your mdb.

 

[mothi]

Hi Code ONDELETE

Private Sub Form_Delete(Cancel As Integer)

Dim db As DAO.Database
Dim cin As String
Dim table As String

cin = Nz(Me.frm_part_cin)
table = Me.RecordSource

end sub

I am storing them in the temporary variable and i need to use these variables in the AFTERDELCONFIRM event and save the values in a table. Please Help me out. I should use the system prompt message box instead of usercreated message prompt. SO i can't create message prompt , i should only use the system prompt and as i pasted the code above i need to address the ONdelete event in AFTERDELCONFIRM event and store it in a table . Please Help me out.Please