Updating with a refresh every record may be take too long. One approach you might consider is to run an SQL command to grab all the to-be-processed records into a cursor - which let's you show the regular progress bar via

SET NOTIFY ON
SET TALK ON

You can then treat the cursor as a readonly record set and do REPLACE ALL (which is very fast).


>What is the simplest way to show progress of a procedure (eg., looping thru a table and showing a specific field as some procedure is being run on that record) on a simple form?
>
> Example: field name is CONTRACT. I want a simple form that shows label "CONTRACT NUMBER:" and text box that shows the CONTRACT NUMBER. Is there a way to refresh a FORM from outside the form?
>
>Ie, call the form from within the procedure - then refresh it everytime the CONTRACT NUMBER changes?
>
>TIA
>
>Harry Jr.