Listbox "On Not In List" Property

[kdbailey]

I am running a form in which the user needs to select an item that is included in the listbox. If the item is not in the listbox, I want a messagebox to come up and then it redirect you back to focusing on the listbox. I am unclear how to get this event to trigger. Every time I run the form and exit a listbox with something that is not part of the list, it does not trigger.

I want it to be ok with being blank or with something from the list. How do I get this to trigger?

[RuralGuy]

Are you talking about a ListBox or a ComboBox?

[rpeare]

I'm with RG on this, if you're using a list box, it's not physically possible to select something that's not in it. If you're talking about a combo box and if they type in something that's not available a default warning message appears, but you can change that if you want you just have to change the LIMIT TO LIST property.

The easiest way to do this is to trap the error after setting the 'limit to list' property then in the ON EXIT property of the combo box use something like:

if err.number = <error number here> then
    <put your combo box name here> = null
    docmd.gotocontrol ("<put a control name that is always visible and enabled on your form here>")
    docmd.gotocontrol ("<put your combo box name here>")
endif

[kdbailey]

Thanks for the quick responses.

In the meantime however I did find the "Limit to List" property somehow was set to No on a few of my listboxes. Not sure how this happened, but I was testing all of the listboxes and it would toss up an error on some and not on the others so I just searched for the difference between the two.

For some reason I am having trouble with a very similar but different issue though. I'll start a new thread regarding it.