Setting a flag based on a background count
This seems like it should be simple, but I'm stuck. My file opens to a main data entry layout. I want to be able to display a reminder flag on the screen -- "Records need processing," for example -- if records exist in the database having a trigger date = current date. After I've processed the records, the reminder needs to disappear.
I can use conditional formatting to make the reminder appear and disappear, and it seems like I should be able to do a find in the background, then Get(FoundCount), and change the formatting based on count = 0 or >0. This can be attached to the OnRecordLoad trigger of the main layout. I'm just not sure how to get that count. Do I have to open a new window and a new layout every time, run the find, then close the window? Seems like there should be a better way.
Unfortunately, my years of MS Access coding are creating a mental block on this.