Solved Could someone help me with this IF function?

[gojets1721]

I'm trying to display a msgbox if any of 5 different values is present in a field AND if a separate field is null. Here's what I have so far but its erroring out as a data mismatch.

Any suggestions?

If "[Field1] IN ('value1','value2','value3','value4','value5')" AND IsNull(Field2) Then
     MsgBox "Message for User"
End If

 

[Solo712]

I'm trying to display a msgbox if any of 5 different values is present in a field AND if a separate field is null. Here's what I have so far but its erroring out as a data mismatch.

Any suggestions?

If "[Field1] IN ('value1','value2','value3','value4','value5')" AND IsNull(Field2) Then
     MsgBox "Message for User"
End If

Select Case [Field1]
   Case 'value1', 'value2', 'value3', 'value4', 'value5'
       MsgBox "Message for User"
   End Select

Cheers,
Jiri

 

[gojets1721]

Select Case [Field1]
   Case 'value1', 'value2', 'value3', 'value4', 'value5'
       MsgBox "Message for User"
   End Select

Cheers,
Jiri

Thank you. How would I include field2 needing to be null?

 

[arnelgp]

Select Case [Field1]
   Case 'value1', 'value2', 'value3', 'value4', 'value5'
          If IsNull([Field2])
           MsgBox "Message for User"
       End If
   End Select

 

[gojets1721]

Select Case [Field1]
   Case 'value1', 'value2', 'value3', 'value4', 'value5'
          If IsNull([Field2])
           MsgBox "Message for User"
       End If
   End Select

That worked!! Thanks!