I have a parent form (receiveF) and a continuous subform (receiveListF) where users can enter inventory items. I'm trying to add functionality to the form that asks the user if they want to save the changes to the form or undo the changes. Richard has a great video on this topic with a single form that I used but it opens when the user tabs from the parent form to the subform. Here is some code that I last tried that still does not work:

Details

Private Sub Form_Unload(Cancel As Integer)
    ' Only check for unsaved changes if not switching to subform
    If Me.Dirty And Not (Me.ActiveControl Is Me.ReceiveListF Or Me.ActiveControl.Parent Is Me.ReceiveListF) Then
        Call Form_BeforeUpdate(Cancel)
    End If
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)
    ' Ensure the prompt only triggers when actually closing
    If Not Me.NewRecord And Me.ActiveControl.Parent Is Me.ReceiveListF Then Exit Sub

    Dim response As Integer
    response = MsgBox("Do you want to save your changes?", vbYesNoCancel + vbQuestion, "Confirm Save")

    Select Case response
        Case vbYes
            ' Proceed with saving
        Case vbNo
            Me.Undo ' Undo changes made to the form
        Case vbCancel
            Cancel = True ' Cancel the close action and keep the form open
    End Select
End Sub
Copy

Any idea how to stop the BeforeUpdate msgbox from running if the user tabs to a subform? Thanks in advance for your help.