While running an from a click event procedure I run several subroutines 

that open recordsets, delete data, open excel, and update recordset from 

excel. Before each subroutine call I update a label caption and do a 

me.refresh but the label does not update unless I stop execution with a 

msgbox. I've tried loops and timeinterval but nothing seems to cause the 

label or form to refresh properly time until the end of the event 

procedure but does not show anything but the last label.caption update. 

Any suggestions on forcing a label.caption or textbox update

Have you tried using me.repaint? This should force the screen 

to update.



Brian

---- Original message ----

>Date: Wed, 7 Mar 2001 23:19:16

>From: "Bob Cooper" <rpcabq@a...>

>Subject: [access] Updating a Status Label

>To: "Access" <access@p...>

>

>While running an from a click event procedure I run several 

subroutines 

>that open recordsets, delete data, open excel, and update 

recordset from 

>excel. Before each subroutine call I update a label caption 

and do a 

>me.refresh but the label does not update unless I stop 

execution with a 

>msgbox. I've tried loops and timeinterval but nothing seems 

to cause the 

>label or form to refresh properly time until the end of the 

event 

>procedure but does not show anything but the last 

label.caption update. 

>Any suggestions on forcing a label.caption or textbox update

Use the DoEvents instead of me.refresh



John Ruff - The Eternal Optimist :)

 -----Original Message-----

From: 	Bob Cooper [mailto:rpcabq@a...] 

Sent:	Wednesday, March 07, 2001 11:19 PM

To:	Access

Subject:	[access] Updating a Status Label



While running an from a click event procedure I run several subroutines 

that open recordsets, delete data, open excel, and update recordset from 

excel. Before each subroutine call I update a label caption and do a 

me.refresh but the label does not update unless I stop execution with a 

msgbox. I've tried loops and timeinterval but nothing seems to cause the 

label or form to refresh properly time until the end of the event 

procedure but does not show anything but the last label.caption update. 

Any suggestions on forcing a label.caption or textbox update

Did you try DoEvents function to allow the operating system to catch up.



_____________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209