MS Access ScreenUpdating = false?
Posted on 2008-06-19
In Excel I can "freeze" the appearance of the window while a macro runs in the background updating various cells in a spreadsheet and then "unfreeze" the screen to reveal all of the changes. Do this eliminates screen flicker and other various unattractive visual actions while a macro is running.
Can the same thing be accomplished in MS Access? I have a couple of subforms that require my using Me.Requery to get data content up-to-date after a user enters some data. Unfortunately, I'm seeing some weird data momentarily appear in the subform that eventually disappears after the Me.Requery completes.
Is there a way to "freeze" the display of MS Access until the Me.Requery finishes?