Some Code being ignored - Posted in wrong Forum - Have re-posted

[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 ?

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[GPGeorge]

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 ?

Try sprinkling DoEvents in the code, after your attempts to raise signals with the hourglass and label. That might help.

 

[Minty]

I answered this in the previous thread, which appeared to be in the right place.

Me.Repaint

 

[pbaldy]

Welcome aboard. I moved your thread to a more appropriate forum.