<div>
<div class="content wysiwyg-content">
In &nbsp;Excel I can &quot;freeze&quot; the appearance of the window while a macro runs in the background updating various cells in a spreadsheet and then &quot;unfreeze&quot; the screen to reveal all of the changes. Do this eliminates screen flicker and other various unattractive visual actions while a macro is running.<br />
<br />
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. <br />
<br />
Is there a way to &quot;freeze&quot; the display of MS Access until the Me.Requery finishes?
</div>
</div>


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?

MS Access ScreenUpdating = false?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.