Solved Some VBA Code Being Ignored (1 Viewer)

[Badger1961Uk]

The following is in an after update event of a form :-

If Not IsNull(ProposedInspectionDate) Then
DoCmd.Hourglass True
lblPleaseWait.Visible = True
Forms![_Assign_Inspections].Form.Refresh
Call CalculateOutstandingTanks
lblPleaseWait.Visible = False
Forms![_Assign_Inspections].Form.Refresh
End If

The Hourglass, llblPleaseWait.Visible and Refresh commands are being ignored but the system processes the cone in the Proceedure Call.

However, if I preceed the code with the Stop Command and then step through the code manually, the commands all work.

Any ideas anyone ?

 

[Minty]

Try a
Me.Repaint

After making the label visible, also it could be happening so fast you don't see it.

 

[Badger1961Uk]

Try a
Me.Repaint

After making the label visible, also it could be happening so fast you don't see it.

Thanks, the Me.Repaint works