T
Tracey
Hi I hope you can help.
I'm trying to set up a code so that if one field has "Email" in it
then the "email address" field needs an email address.
This is what I have at the moment:
IIf([tblCorrespondence]![strTypeofCorrespondence] is "Email",
MsgBox("Enter Email Address",vbCritical, "Enter Email Address"),"<>"))
but this comes up with an error message: "Compile error: Expected: end
of statement"
What am I missing?
I'm trying to set up a code so that if one field has "Email" in it
then the "email address" field needs an email address.
This is what I have at the moment:
IIf([tblCorrespondence]![strTypeofCorrespondence] is "Email",
MsgBox("Enter Email Address",vbCritical, "Enter Email Address"),"<>"))
but this comes up with an error message: "Compile error: Expected: end
of statement"
What am I missing?