You can run the Echo action more than once in a macro.This allows you to change the status bar text while the macro runs.
You can use dialog boxes and pop-up forms to gather or display information, even if echo is turned off.To suppress all message or dialog boxes except error message boxes and dialog boxes that require the user to enter information, use the Set Warnings action.When you set the Echo On argument to No, the macro runs without updating the screen.When the macro finishes, Access automatically turns echo back on and repaints the window.The Set Value action sets the Supplier ID control on the Products form to the current supplier on the Suppliers form.
The Go To Control action then moves the focus to the Category ID field, where you can begin to enter data for the new product.
Echo method, which can turn screen updating off while your code is running (just be sure you turn Echo back on! However, it might be worth while to look at your code and determine what is going on that is causing a lot of screen updating.
Because this will prevent a screen change for each item added, it should help quite a bit. Meyers-Jouan" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3898683" / Matt, As Mary has suggested, the simplest way to prevent the flickering is to use the Application.
Note This action will not be allowed if the database is not trusted.
For more information about enabling macros, see the links in the See Also section of this article. When Microsoft Office Access 2007 runs a macro, screen updating often shows information not essential to the functioning of the macro.
This macro should be attached to the Review Products button on the Suppliers form.