MsgBox comand before New Record

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top