How do I update a Label Caption in VBA - Access 2007 ?

Hi,

I have a program loop where the status is changing and I want to display this information through a Label Caption. This is an object on an Access 2007 form. It updates at the end of my loop but not during. How can I make it update each time I change the value?

Thanks, David.

Example: Me.MyLabel.Caption="The status has just changed from 3 to 4."

Select allOpen in new window