Consulting

Results 1 to 3 of 3

Thread: Application.Echo / DoCmd.Echo resets when Form is closed

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Application.Echo / DoCmd.Echo resets when Form is closed

    I have VBA code to close 3 Forms after clicking a Command Button. The Forms close just fine, but there is a lot of flickering while they close so I wanted to turn off the screen updating using Application.Echo or DoCmd.Echo. However, once any of the Forms close, it appears the screen updating setting resets. How can I get the .Echo to remain in place while all the Forms close?

    DoCmd.Echo False
        If CurrentProject.AllForms("Form_1").IsLoaded Then
            DoCmd.RunCommand acCmdSaveRecord
            DoCmd.Close
        End If    
        If CurrentProject.AllForms("Form_2").IsLoaded Then
            DoCmd.RunCommand acCmdSaveRecord
            DoCmd.Close
        End If
        If CurrentProject.AllForms("Form_3").IsLoaded Then
            DoCmd.RunCommand acCmdSaveRecord
            DoCmd.Close
        End If
    DoCmd.Echo True
    Note, I've tried this in the Click, Mouse Down, and Mouse Up Events of the Command Button.
    Last edited by Aussiebear; 05-17-2025 at 05:02 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •