message / popup message box in access forms

[jazz007]

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 this possible in forms. Thanks.

 

[M8KWR]

If the AfterUpadate procedure of the field enter this code

If Field Name >= 14 Then

MsgBox "Over 14 days"

End If


Hope this helps

 

[jazz007]

i have tried this but it does not seem to show a message box
Went to After update, code builder.

Private Sub Column C_AfterUpdate()
If [Column B] - [Column A] >= 14 Then

MsgBox "Over 14 days"

End If

End Sub

Also have tried this and not seem to work

Private Sub Column C_AfterUpdate()
If Column C >= 14 Then

MsgBox "Over 14 days"

End If

End Sub

Am I doing something Wrong, please let me know

 

[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

 

[jazz007]

I dont know what I am doing wrong
I go to ColumnC and right click on After Update, choose code builder, and typed this code

Private Sub ColumnC_AfterUpdate()

ColumnC = ColumnA - ColumnB
If ColumnC >= 14 Then

MsgBox "Over 14 days"

End If
End Sub

I enter data on ColumnA, I enter data on ColumnB, but in ColumnC the calculation happens it Does ColumnA - ColumnB, but even if the answer is more than 14 days no message seems to appear, what seem to be the problem I dont understand. Can anyone Help please Many thanks