How to create an add & delete trigger in subform 1

[Aximboy]

Hello!

Here's what I have...
I have a form with all the client's info (address, telephone, etc) and a subform which contains contract number, approval date, termination date, etc in a continuous form view.

I want Access to automatically send an email whenever a user adds or deletes a record in the subform.

How do I create a trigger for any addition or deletion of record in a subform?  And how do I integrate that with the Docmd. SendObject?

Please help and thank you in advance.

 

[MajP]

you need these in the subform

Private Sub Form_AfterDelConfirm(Status As Integer)
  If Status = acDeleteOK Then
    'your code here
  End If
End Sub

Private Sub Form_AfterInsert()
  'your code here
End Sub

 

[Aximboy]

You are awesome! Thank you so much!