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