is record new

Determine whether the current record is a new record in a form

Sub NewRecordMark(frm As Form) 


    Dim intnewrec As Integer 


intnewrec = frm.NewRecord 
 
If intnewrec = True Then 
MsgBox "You're in a new record." _  
& "@Do you want to add new data?" _ 
& "@If not, move to an existing record." 
End If 


End Sub

Quelle: https://docs.microsoft.com/en-us/office/vba/access/concepts/forms/determine-whether-the-current-record-is-a-new-record-in-a-form