Turning off standard warnings

[Eddy]

I use the following code to behind a combo box. It fires on the Not In List
property.

If IsNull(Field1) Then
intAnswer = MsgBox("You must first input Data in Field1" _
, vbOKOnly + vbCritical, "Field1 Empty")
If intAnswer = 1 Then
Exit Sub
End If
End If

The code works fine but after I exit the sub I get the standard message
telling me the item I entered was not an item in the list. Is there any way
to turn off this message?

Thanks

 

[PC Datasheet]

Look at the Not In List event in the Help file; it will show you how to turn
off the message.