Form mode "Create" v. "Revise"

[Jwy]

Is there a way I can tell if a form is in "Create" mode v. "Update" mode"? I want to send an email when a form is being Created, but not when a form is being Updated. Currently I'm sending an email everytime the form is saved...this is nonsense. Any help is appreciated.

 

[Pat Hartman]

In the BeforeUpdate event of the form, you can check the NewRecord property.

If Me.NewRecord Then
    'send Email
End If

It is actually safer to put the code in the form's AfterUpdate event because that way the record has really been saved but the NewRecord property will no longer test true at this point so you need to create your own variable. Set it in the BeforeInsert event, check it in the AfterUpdate event, and reset it in the Current event.