I have some flags that are set in checkboxes, the true/false setting of each being set by another program acting as a data collection agent -- it is reading instruments, and then sending the data to my Access app. If a reading falls out of spec, these flags are set directly in the table. The record is opened by my form, and setup and close down data entered in this same form; the data collection app is in between.
When checked, they trigger the appearance of labels acting as Notices on my Access form. I initially put them on the Current, and they show when focus leaves and comes back. However, I need them to be visible as soon as possible after the flags are set to true. The checkboxes are hidden controls, so Focus is never there, nor are they ever updated or changed -- just the underlying field is.
To get this to happen, which event does not need action on the control, but will tell the form the record has changed and to react to the code to set the labels? I thought AfterUpdate might do it, but cannot tell if it wants the form to do the updating or will react to changes made to the underlying record, almost immediate.
Any ideas would be appreciated