A
Alan
Can someone explain why this isn't working and what I need to do to make it
work. I have a form with three fields that need users to input a number value
and a fourth field on the same form which calculates the average of the three
values the user inputs. This works fine but I want a message box to appear
when the calculated average in the fourth field exceeds a certain value and I
can't get this to work - BeforeUpdate, AfterUpdate, Change won't trigger my
VBA MsgBox code even though the calculated average has exceeded the limit I
set.
TIA
work. I have a form with three fields that need users to input a number value
and a fourth field on the same form which calculates the average of the three
values the user inputs. This works fine but I want a message box to appear
when the calculated average in the fourth field exceeds a certain value and I
can't get this to work - BeforeUpdate, AfterUpdate, Change won't trigger my
VBA MsgBox code even though the calculated average has exceeded the limit I
set.
TIA