The acb Show Updates method really doesn't do much besides what a direct call to Application.Echo does: As a matter of fact, the reason this procedure exists at all is because the techniques used in this topic work great in Access 2002 and later, but may not work correctly in earlier versions?
When Access runs a macro, screen updating often shows information not essential to the functioning of the macro.
When you set the Echo On argument to No, the macro runs without updating the screen.
Disabled Enabled 0.61909653 2.105066913 0.619555829 2.106865363 0.620805767 2.106866315 0.625528325 2.102403315 0.625319976 2.0991179 0.621287448 2.105103142 0.621540236 2.101392665 0.624537531 2.106866716 0.620401789 2.109004449 There is one important thing to know about screen updating which I didn’t see in any previous answer.
From my own test I find out that turning screen updating off and on takes about 15ms (tested in C# via Excel Interop).
The Echo action doesn't suppress the display of modal dialog boxes, such as error messages, or pop-up forms, such as property sheets.
You can use dialog boxes and pop-up forms to gather or display information, even if echo is turned off.The following macro opens the Product List form in the lower-right corner of the Suppliers form, displaying the current supplier's products.It shows the use of the Echo, Msg Box, Go To Control, Stop Macro, Open Form, and Move Size actions.Keep that on mind if you will execute anything which would take less time.And after all don’t turn screen updating on/off many times in some loop. And one more note (which you probably don’t want to hear) if you want it quick use C .It also shows the use of a conditional expression with the Msg Box, Go To Control, and Stop Macro actions.