Form Blinking

[Tom]

In MS Access 2000:
When I change forms, the screen blinks while the form
updates. Is there a way to freeze the screen while the
update (queries, refresh,...) are being executed in a
macro? I just split the database, and it got worse.
I connected the front end to a SQL server backend, and it
got even worse.

 

[Paul Overway]

You can use Application.Echo False....and then Application.Echo True. If
you are using macros, Echo.

 

[Van T. Dinh]

Use Echo False to stop the screen refresh and then Echo True to continue.
You can either use Echo Method of the DoCmd Object or the Application
Object.

A note of caution: Make sure the Echo True statement is executed (using
error-trapping code), even when the code errors out. Otherwise, the screen
will appear frozen. Also beware when you step through the code as well.