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

[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.

 

[Dennis]

All,

I'm using Access on XP Office Pro 2003 w SP3 on XP Pro w SP3.

 

[Allen Browne]

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

 

[Dennis]

Allen,

Once again I am indebted to you. This worked well.