Navigation Button Events

clauses

Registered User.
Local time
Today, 20:01
Joined
Feb 9, 2001
Messages
56
Are there events associated with the use of a navigation button. I have a form and when the users uses a navigation button to enter a new record I would like to update a field on the file. I have looked through several books and have been unable to find much regarding the use or custmazation of the navigation toolbar.
 
Sounds like you need to test for a new record in the forms on current record event.

Code:
Private Sub Form_Current()
On Error GoTo Err_Form_Current

    If Me.NewRecord Then
        MsgBox "new record detected."
    Else
        MsgBox "non new record detected."
    End If
    
Exit_Form_Current:
    Exit Sub

Err_Form_Current:
    MsgBox Me.Name, "Form_Current", Err.Number, Err.Description
    Resume Exit_Form_Current

End Sub

HTH
 

Users who are viewing this thread

Back
Top Bottom