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

  • Article
Access Developer Reference

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