MsgBox..Expected End of Statement

[Duck]

This seems like it should be simple, but I can't figure out the
error. I have button on a form that print out a report if the client
whose record appears on the form has achieved a certain status (Phase
III). However I keep getting this error: Compile error: Expected End
of Statement

intAnswer = MsgBox [FirstName] & " " & [LastName] & " Is Not Phase
III...Print Itinary Anyway?", vbYesNo, "Not Phase III"

 

[JulieS]

This seems like it should be simple, but I can't figure out the
error. I have button on a form that print out a report if the
client
whose record appears on the form has achieved a certain status
(Phase
III). However I keep getting this error: Compile error: Expected
End
of Statement

intAnswer = MsgBox [FirstName] & " " & [LastName] & " Is Not Phase
III...Print Itinary Anyway?", vbYesNo, "Not Phase III"

I believe you are missing the open and close parentheses.
Try:

intAnswer = MsgBox ([FirstName] & " " & [LastName] & " Is Not Phase
III...Print Itinary Anyway?", vbYesNo, "Not Phase III")

I hope this helps.
Julie

 

[boblarson]

Duck:

Just so you know - if you have a function and you are assigning it to
something like:

intAnswer = MsgBox ([FirstName] & " " & [LastName] & " Is Not Phase
III...Print Itinary Anyway?", vbYesNo, "Not Phase III")

then you have to use the parentheses. If you are just DISPLAYING the
message box then you don't:

MsgBox [FirstName] & " " & [LastName] & " Is Not Phase
III...Print Itinary Anyway?", vbOK, "Not Phase III"

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________