Prev: need an acDialog clarification
Next: Selecting Printer Tray for Mail Merge
From: Mark Kubicki on 19 Apr 2010 19:02
on a subform, I have a command button that assigns values to and then makes
visible a couple of the controls (picture box and a label) on the main form

it works fine; however, it looks like the entire screen is updating; is
there a way to limit the update to the specific controls being referenced?

many thanks in advance,
mark


From: Jeanette Cunningham on 19 Apr 2010 20:56
You can hide the repainting of the screen from the user like this:
Put DoCmd.Echo False at the start of the code that does the updating of the
controls.
Be very careful to make sure that you use
DoCmd.Echo True
in the Exit statement for that Sub or Function.

If however, you mistakenly leave echo off, the user will not be able to
interact with the database and it will appear frozen.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Mark Kubicki" <Mark(a)TillotsonDesign.com> wrote in message
news:eagTfRB4KHA.4952(a)TK2MSFTNGP02.phx.gbl...
> on a subform, I have a command button that assigns values to and then
> makes visible a couple of the controls (picture box and a label) on the
> main form
>
> it works fine; however, it looks like the entire screen is updating; is
> there a way to limit the update to the specific controls being referenced?
>
> many thanks in advance,
> mark
>


 | 
Pages: 1
Prev: need an acDialog clarification
Next: Selecting Printer Tray for Mail Merge