Form Refresh Problem

[ThisIsntMyRealName]

Hi guys, I have a form displayed to the user in ACCESS 2007. When a user clicks on a button, it runs an agent that performs some actions. During the running of the agent, I'd like to set a textbox back on the form itself. The only problem is that the textbox only updates 3 times during the course of the agent, even though its supposed to be updating about 300 times or so, or as many loops as the code takes. Any hints on getting it to update more frequently? here is the code:

'LET USER KNOW OF STATUS OF AGENT
Forms!frmAdage_IMMP_Import!TxtProgramStatus.Value = "Processing Excel Rows..." & iCounter
DoCmd.Requery

'THIS UPDATE FOR THE STATUS BAR WORKS JUST FINE
strTempStatus = SysCmd(acSysCmdSetStatus, "Processing Excel Rows..." & iCounter)

 

[Montez659]

Try researching these and see if either of these will help:

Me.Recalc

or

Me.Repaint

With the Repaint, you might need to reference a specific object and not just the form itself. If so, just add it in there.

 

[boblarson]

Add a

DoEvents

between the lines of code.

 

[Montez659]

Bob, I know I have probably asked this before, but I still can't grasp what DoEvents does and how it works. Placing DoEvents in between the lines of code will do what?