Message Box Compile Error 1

[BV874]

Hi,
I get a Compile Error: Expected:= on the following "OK" message box I am trying to create.

Private Sub DUE_DATE_AfterUpdate()
If Me!DUE_DATE < Me!PMTPOSTDT + 29 Then
MsgBox("The Next Due Date Falls within 30 days!",vbExclamation,"Warning")
End Sub

I am not sure what is wrong here. Thanks.

 

[PHV]

Use either this:
Call MsgBox("The Next Due Date Falls within 30 days!",vbExclamation,"Warning")
or this:
MsgBox "The Next Due Date Falls within 30 days!",vbExclamation,"Warning"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

Private Sub DUE_DATE_AfterUpdate()
If Me!DUE_DATE < Me!PMTPOSTDT + 29 Then
MsgBox "The Next Due Date Falls within 30 days!",vbExclamation,"Warning"
End Sub

 

[BV874]

Thank you.