Hide values list in combo box

[dim]

Hi,

I have a form with a combo box [Operator] where the Auto expand propriety = No.
I added an event "On not in list" me.operator=""
When a user tape a value which is not in the list, after press on enter the field will become empty (which is ok) and the message "The text you entered isn't an item in the list" appear which is normal.
My problem is that after the user click on OK to this message the list of possible values appear.
There is a way to keep this auto expand propriety = No even after close the Access message "The text you entered isn't an item in the list" ?

Thanks a lot!

 

[dim]

I found a solution to my problem:

Private Sub Operator_NotInList(NewData As String, Response As Integer)
SendKeys Chr(vbKeyEscape)
Me.operator = ""
SendKeys Chr(vbKeyEscape)
End Sub