How do I provide my own message when an item is not in a list? I have been able to create the message in the "NotInList" event, but I still get the generic Access message after my message. I would like to keep the generic message from displaying. I tried setting the "Limit to list" criteria to "No", but then it didn't hit my VBA code either.
Code:
Private Sub cboRegion_NotInList(NewData As String, Response As Integer)
On Error GoTo ErrorHandler
MsgBox "No contact information for this Region!" & vbCrLf & vbCrLf & "Please enter Region Contact information" & _
" in ""Manage RVPs by Division"".", vbCritical, "Invalid Region"
Exit Sub
ErrorHandler:
MsgBox "Critical Error!" & vbCrLf & vbCrLf & Err.Description, vbCritical, "Error # " & Err.Number
End Sub