Get rid of not in list msbox

[Shawny]

I would like to stop the automatic box that comes up when data is entered that is not in the list in a combo box , and the 'limit to list' property is set to yes. I want to put a macro on the 'not in list' property to do some things that I want the user to do. The auto not in list box is in the way and confusing.
If the only way to do this is VBA, I would also like to hear the answer.
Thanks

 

[Rich]

Search here for examples, many have been posted