How can I check if a combo box value is in the rowsource?

[Vita]

So I have a combobox that is a list of employee names and I have "limit to list" set to yes but when you enter something that isn't in the list it comes up with an error message that says "The text you entered isn't an item in the list." and I was requested to change that to say something simpler such as "Please select a name from the list".

I thought this could simply be accomplished by doing something like checking if the combo box value is in the combo box row source (Which is a query) but it turns out that the row source isn't considered an array or collection so I can't cycle through it using a for loop. Is there a better way to check if it is in the row source or not?

[ranman256]

you dont have to. If you have LIMIT TO LIST = true, then the box will yell at you if the item is NOT in the list.

[Welshgasman]

https://www.msaccesstips.com/2010/06...o-box.html?m=1

[orange]

If, it turns out that, you want to easily add a new value, you should watch this youtube video.

[Vita]

https://www.msaccesstips.com/2010/06...o-box.html?m=1

This is EXACTLY what I was looking for! Thank you Welsh! You're always such a great help!
I did not realize there was an event for it and I just used it to send a message box with the prompt I wanted and set "Response = 0" so that the default response doesn't pop up.