Error Message

[Guest]

I have a command button that prints a report.
I want to create an error message that pops up when a text feild contains a
certain name and also when [Travel Description] and [Facilities] is blank.

If the error message pops up I do not want to print the report. If it does
not pop up I want it to print the report. I already have the report ready to
print with the command button and also a where condition. So I guess I am
trying to get all of these to work together.
Thanks

 

[Guest]

Try this code

If Me.[text field] = "certain name" Or (Isnull(Me.[Travel Description]) and
IsNull(Me.[Facilities])) Then
MsgBox "error message pops up I do not want to print the report"
Else
Docmd.OpenReport "reportName"
End If
========================================
I'm Not sure about the If, mybe this what you are looking for

If Me.[text field] = "certain name" Or Isnull(Me.[Travel Description]) Or
IsNull(Me.[Facilities]) Then
MsgBox "error message pops up I do not want to print the report"
Else
Docmd.OpenReport "reportName"
End If