Determine if in add record or change record "mode"?

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

All,

Is there a simple way to determine to determine if I'm changing a record or
adding a record while I'm in the form?

All of my records have a date added field which I assign on the Form's
Before Update event, so I could check that field. But I wanted to know if
there was a system flag to tell me in which "mode" the form is current in.
 
To see if you are at a current record or a new record, test the form's
NewRecord property, e.g.:

If Me.NewRecord Then
MsgBox "This is a new record"
Else
MsgBox "This is an existing record"
End If
 
Back
Top