syscmd messages don't update

M

mgc300

I have a code module that steps through the records of a
dataset and performs calculations on that data. To monitor
the progress, I am using a variable counter in conjunction
with the rowcount parm to display a message on the command
bar. "processing row 2 of 98000" is an example. The
messaging works fine unless I click into another window.
At that point in time the message no longer updates, but
the process is still running and completes with no
problems. Any ideas as to how to keep the status bar
updating?
 
A

Allen Browne

Alternative approach to writing to the status bar:
DoCmd.Echo True, "2 of 98000"
 
Top