CommitOnNavigation Property

Returns or sets a Boolean indicating whether the specified form saves changed records when you navigate from one record to another. True if changes are saved when you navigate to another record; otherwise, changes are queued until explicitly saved to the underlying database. Read/write.

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

This property can only be changed during design time. During run time, it is read-only.

Example

The following example checks the specified form to see if changes are saved when the user navigates to another record and displays a message box reporting the result.

With Forms(0)
    If .CommitOnNavigation = True Then
        MsgBox "The """ & .Name & """ form saves " _
            & "changes when you navigate to a new record."
    Else
        MsgBox "The """ & .Name & """ form queues " _
            & "changes as you move from record to record."
    End If
End With