Problem calling for code...

[Roosters]

This will be hard to explain - so here goes

I have a calculated field on a sub form that tallies up hours that my on call staff has worked in the previous 24hrs. When this total exceeds 14 hrs I have a field that displays a warning. Now I have been asked for an audible warning as well. I have the code working to call for the sound but can't work out how to get the code to run when the 14 hrs is reached. i.e. where to put the code? I have tried the On Change of the Warning field and also the On Current of the sub form, but have failed. The recalculating of the times is done every 5 min via the On Timer of the main form - is this why the On Change won't call my code?

Thanks in advance Phil

 

[jiqjaq]

Yes. Most events for fields require human interaction for them to occur. You need to capture the warning where the program is aware of it - in the Timer event.