message / popup message box in access forms

[Jazzy007]

hi
I wonder if anyone can help. In Access forms I have column A and column B and Column C. Column C = Column B - Column A. Now can I have a message box/popup box displayed in column C only if the value is greater than >=14. Message saying over 14 days. if the value in Column c is less than 14 then NO message box/popup box. Is there any scripts that can be used to create this. someone suggested after_update procedure, but not sure what i need to type as i have not done any VBA.

Is this possible in forms. Thanks.

 

[M8KWR]

use the following code:

Private Sub Column_A_AfterUpdate()

Column_C = Column_B - Column_A

If Column_C >= 14 Then

MsgBox "Over 14 days"

End If


End Sub
Private Sub Column_B_AfterUpdate()

Column_C = Column_B - Column_A

If Column_C >= 14 Then

MsgBox "Over 14 days"

End If

End Sub

I have tested it and its all works