Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    wakefield, ri
    Posts
    35

    Unanswered: New Record Notification in a Close Form

    Any ideas on how to set up a pop up message notification for a new record in a closed form?

  2. #2
    Join Date
    Feb 2004
    Posts
    137
    Post the following code into your form's Code Module:
    Code:
    Dim NewRec As Boolean
    
    Private Sub Form_BeforeInsert(Cancel As Integer)
        NewRec = True
    End Sub
    
    Private Sub Form_Current()
        NewRec = False
    End Sub
    
    Private Sub Form_Unload(Cancel As Integer)
        If NewRec = True Then MsgBox "New Record"
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •