not really. Closing the form does not indicate a record update.
youd want the email code ,DOCMD.SENDOBJECT report
in the record AFTERUPDATE event.
in the AFTERUPDATE set a module flag to TRUE.
THEN when the form is closed send the email
ave a form that enters new records into a table. On the form there is a command button that closes the form.
Private Sub Close_Form_Click()
if mbIsDirty then docmd.sendobject report