V
Van T. Dinh
Try:
Screen.Echo False
DoCmd.OutputTo ...
Screen.Echo True
Beware that Echo Off freeze the screen and if the process
takes a long time, the user may think that Access has got
stuck.
And to be safe, you need to trap for *any* error and the
set Echo True to get the screen active again.
See Access VB Help on Echo for arguments.
HTH
Van T. Dinh
MVP (Access)
Screen.Echo False
DoCmd.OutputTo ...
Screen.Echo True
Beware that Echo Off freeze the screen and if the process
takes a long time, the user may think that Access has got
stuck.
And to be safe, you need to trap for *any* error and the
set Echo True to get the screen active again.
See Access VB Help on Echo for arguments.
HTH
Van T. Dinh
MVP (Access)