updating a form

[FacilitiesCAD]

I currently have a button on a form that runs some vb code that takes about 45 sec to run. Because thats a relatively long time to think your computer has frozen up, I want to change text in a text box me.text10 to different values in the code. IE me.text10 = "Starting", me.text10 = "step1 complete". These values do change but they don't show up on the form until everything is done. How do you force an update or refresh to the form or just the text box. I first used msgbox but I don't want people to have to click OK each step of the way.

Tim

 

[luceze]

If your code is running a query then the form will not update until after the query is done. If it is running several queries, then between each query change the text on your form then use repaint to refresh your form.

HTH,
Eric