How to: Determine Whether The Current Record is a New Record In a Form

The following example shows how to use the NewRecord property to determine if the current record is a new record. The NewRecordMark procedure sets the current record to the variable intnewrec. If the record is new, a message notifies the user. You could call this procedure when the Current event for a form occurs.

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