Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NotInList event does not fire

Status
Not open for further replies.

xinyin

Programmer
Jan 16, 2003
81
HK
I have a combo box which it got its source data from a table. I want it to automatically detact the user input: if the user input something which is not in the list, a msgbox appears telling the user about this. I put the msgbox code in the NotInList event. However, this msgbox does not appear when I input some not-in-the-list data, it indicates the NotInList event does not fire, why?
 
Hi
Have you looked at LimitToList?
Microsoft said:
The LimitToList property must be set to Yes for the NotInList event to occur.

 
Oh, I overlooked this one. Now I set it to Yes and it works. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top