DoCmd.Close not working as expected (From 12-6-2016!)

[GraeagleBill]

I knew there was something familiar about the error I hit today, see post number 5:



https://www.accessforums.net/showthread.php?t=63255

I had to add "Exit Sub" to my code before I could get the form to close without coughing on the remaining statements in the OPEN code. One might have to suspect that I've discovered yet another of my life's nemesis?

Private Sub Form_Open(Cancel As Integer)

If Me.RecordsetClone.RecordCount = 0 Then
    MsgBox "There are no ""un-cleared"" deposits to show."
    DoCmd.Close acForm, Me.Name
    Exit Sub
End If

strLastReconcile = Me.OpenArgs
Me.lblLR.Caption = "(Beginning with date: " & strLastReconcile & ")"
Me.ChkCleared.SetFocus

End Sub

[Micron]

Yes, the remaining code of a form will execute if you don't exit - even if you cancel the open event. Odd, I know. However, if you cancel the event you don't need DoCmd.Close, but you still need to exit to prevent other code from being executed.

[GraeagleBill]

It does seem odd that execution of subsequent code continues as though nothing else had been directed. Sort of like kids when you tell them to stop what they're doing.
Thanks,
Bill

[Micron]

It does seem odd that execution of subsequent code continues as though nothing else had been directed. Sort of like kids when you tell them to stop what they're doing.
Thanks,
Bill

LOL! Nice analogy