Echo Freeze

[DS]

Anyone know why Echo Freezes some Macros when its used? Does it have
anything to do with queries or passing values from one form to the next?
Thanks
DS

[Patrick Fisher]

As a general rule as you have not provided a specific case, You must
turn Echo back on as soon as the reason for its use has gone if for
example you are turning echo off when opening a Report to avoid the
white flash that sometimes occurs, you must turn it on again before
the next item in the code or macro

i.e.

DoCmd.Echo True
DoCmd.OpenReport "rptSuppliers", acViewPreview
DoCmd.Echo False

Patrick

On Thu, 14 Oct 2004 20:17:36 GMT, DS <bo******@optonline.net> wrote:

Anyone know why Echo Freezes some Macros when its used? Does it have
anything to do with queries or passing values from one form to the next?
Thanks
DS

[DS]

Patrick Fisher wrote:

As a general rule as you have not provided a specific case, You must
turn Echo back on as soon as the reason for its use has gone if for
example you are turning echo off when opening a Report to avoid the
white flash that sometimes occurs, you must turn it on again before
the next item in the code or macro

i.e.

DoCmd.Echo True
DoCmd.OpenReport "rptSuppliers", acViewPreview
DoCmd.Echo False

Patrick

On Thu, 14 Oct 2004 20:17:36 GMT, DS <bo******@optonline.net> wrote:

Anyone know why Echo Freezes some Macros when its used? Does it have
anything to do with queries or passing values from one form to the next?
Thanks
DS

Found the problem. I was calling a Macro from VBA code. Thats why it
froze. Thanks.
DS