You can use the NewRecord property to determine whether the current record is a new record.
Setting
The NewRecord property uses the following settings.
| Setting | Description |
|---|---|
| True (–1) | The current record is new. |
| False (0) | The current record isn't new. |
The NewRecord property is read-only in Form view and Datasheet view. It isn't available in Design view. This property is available only by using a macro or Visual Basic.
Remarks
When a user has moved to a new record, the NewRecord property setting will be True whether the user has started to edit the record or not.