Combo Boxes - Prevent Error Message when losing focus to user clicking a button

[Kirtap]

Hello,



Let me first describe the situation.

I have a combo box on a form that the user is limited to the items that populate it. However, I'm having trouble with the message that pops up if they type an item in the textbox portion not in the list and then click off the text box/combobox. There are four buttons on the form, one of them being a submit button in which it is appropriate to show the error message. However, if they click cancel or one of the other buttons and what they typed is like not in the list or half of what they typed, I would like to prevent the message from popping up in such a case. Currently, they can click a button again after the error message to do the necessary action the button calls, but it'd be nice to only have the user click once without that message popup.

How could I go about this? Is there an event I could catch like the combo box loses focus or if there is a button click I can target and set the textbox to be empty?

Thankyou in advance.

[RuralGuy]

Have you explored the "Limit to list" property and the "Not In List" event yet?

[uk123]

Hello,

Let me first describe the situation.

I have a combo box on a form that the user is limited to the items that populate it. However, I'm having trouble with the message that pops up if they type an item in the textbox portion not in the list and then click off the text box/combobox. There are four buttons on the form, one of them being a submit button in which it is appropriate to show the error message. However, if they click cancel or one of the other buttons and what they typed is like not in the list or half of what they typed, I would like to prevent the message from popping up in such a case. Currently, they can click a button again after the error message to do the necessary action the button calls, but it'd be nice to only have the user click once without that message popup.

How could I go about this? Is there an event I could catch like the combo box loses focus or if there is a button click I can target and set the textbox to be empty?

Thankyou in advance.

See the link for not in the list event http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[Kirtap]

Hey guys, thanks. Sorry for the late response. Can't believe I totally missed the NotInList event. I can suppress the message from displaying. Now my only problem is that the combobox gains focus after the NotInList event. Is there a way to prevent this so that if Cancel is clicked, the form just closes?

Thanks.