NotInList Event
The NotInList event is triggered whenever the user enters a value in the text portion of a combo box that is not found in the list portion.
TDBCombo_NotInList (NewEntry as String, Retry as Integer)
Arguments
NewEntry is a string representing the text that was entered by the user but not found in the list.
Retry is an integer that may be set to True in order to force the control to requery the list for the new entry.
Event applies to TDBCombo control.
You can add the new value to the row source within this event, then set the Retry argument to True in order to force the control to requery the list and reposition the selected item to the newly added record. By default, Retry is 0, which indicates that no further searching should occur.
If you set Retry to True in consecutive firings of this event, and the combo still cannot locate NewEntry, then this event will not fire again until the user changes the search string by typing or deleting characters.
Note: This event is only fired when the LimitToList property is True and the user presses the Enter key while the list portion of the combo is closed.
See Also