Refreshing a form

[Keith]

I have a form with a button which runs a routine. I also have a field on
the form that I want to say how many times the routine has go round a
loop in the code. I have line in the loop to do this, but the field on
the form only updates after the whole thing is finished. I presume this
is due to Access being to busy to refresh the form, even though I have
put in a refresh command. How can I force the form to be updated? I
know the rest of it works fine because if I let the routine run to the
end or break out of the code the field updates.

Anybody got any ideas?

 

[Douglas J Steele]

Try putting a Me.Repaint after you increment the loop. You may also need a
DoEvents.

 

[Arvin Meyer [MVP]]

I haven't seen your code, but I tried a similar experiment on my machine.
Using a loop that went for 1 million iterations, it appeared as though I was
duplicating your results. Then I set a breakpoint in the code and stepped
through it. My form updated properly. So my conclusion was that the computer
was simply too fast for me to see the text box change. Make sure that you
have a line in your loop that reads something like:

Me.Text1 = loop counter

then try setting a breakpoint and stepping through your code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access