Progress Form or Status Update Form

[Terri]

I have a form that imports and updates several tables.
The files are very large and the progress meter does not
give enough information. I would like to create a form
that displays the current record number and completion
percentage as the table is processed. The problem that I
have is the form does not update as it moves through the
table. It only displays the final numbers once the
processing is complete. Any ideas would be greatly
appreciated.

Thank you, Terri

 

[Marshall Barton]

I have a form that imports and updates several tables.
The files are very large and the progress meter does not
give enough information. I would like to create a form
that displays the current record number and completion
percentage as the table is processed. The problem that I
have is the form does not update as it moves through the
table. It only displays the final numbers once the
processing is complete.

Immediately after you set the form's progress info, add a
line of code to force the screen update:

Forms!theform.Repaint

or if your import code is actually running in the progress
meter form, just:

Me.Repaint

If that doesn't take care of it, you may also have to add
another line after the Repaint:

DoEvents