I have an HR database with an Attendance Occurence form (which feeds the table) that tracks when an employee is absent, late, leaves early, etc, Each of those has a value: 1 for absent, .5 for late and so on. I want to have a pop up/notification so when the value reaches a certain amount eg. “Employee A has 3 Occurences.” I will send an email to the supervisor regarding the issue. I have watched the pop up videos but they were for timed occasions.

Chatgpt told me to create and attach a macro to the form but it didn’t work.

I don’t exactly know when the pop up should happen, I guess when the data is added  to the form and the value has been reached for the employee? Thank you for your help.