Value when Not In List

[Brian]

In a couple of critical places, I use a filtered Row Source where I would
really like to tell the user WHY the item is not on the list. That is, is it
missing because it does not exist or because it is filtered out.

How can I trap the value the user typed In Control_NotInList for use in my
lookup queries. The value of the control is null at the time the NotInList
event fires. What property of the control contains the value the user
actually typed in there at this point?

 

[Chris]

Did you try:

Private Sub Combo20_NotInList(NewData As String, Response As Integer)
MsgBox NewData
End Sub


Chris