Pop up help

[ptrifile]

I currently use the following code to have a box popup if a certain field is blank

If (IsNull(detailed_reason)) Then
        MsgBox "Please choose a Company", vbExclamation
        Cancel = True
    End If

I need help in modifying this so that the popup only pops up if another field [reason] has the text "Scheduling issue" in it AND the [detailed_reason] is blank.

Thank you for any help

Paul

 

[SgtJarrow]

If (IsNull(detailed_reason)) AND [reason] = "Scheduling issue" Then
        MsgBox "Please choose a Company", vbExclamation
        Cancel = True
    End If

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer