Form.NewRecord (Access)

You can use the NewRecord property to determine whether the current record is a new record.

The NewRecord property is read-only in Form view and Datasheet view. It isn't available in Design view. When a user has moved to a new record, the NewRecord property setting will be True whether or not the user has started to edit the record.

Sub NewRecordMark(frm As Form) 
 Dim intnewrec As Integer 
 
 intnewrec = frm.NewRecord 
 If intnewrec = True Then 
 MsgBox "You're in a new record." _