Forum Discussion
Finlay McMillan
Apr 13, 2025Copper Contributor
Msaccess Enhanced Message Box - Office update issue
This Code has been working for 10 years. Then, an Office update causes multiple instances of the form to remain open. If I revert to 16.0.17531.20120 all is well. This creates multiple inst...
Finlay McMillan
Apr 15, 2025Copper Contributor
Thanks for your responses.
I added the following code as a workaround:
' cleanup
Set F = Nothing
'
' Fix to ensure form closes after user response
'
Dim I As Integer
For I = Forms.Count - 1 To 0 Step -1
If Forms(I).Name = "frmEnhancedMessageBoxFormDialog" Then
DoCmd.Close acForm, Forms(I).Name, acSaveNo
End If
Next I