Need ComboBox need help asap

[azfen]

Hi. I have a combobox in the form. When I start to type in text value in combo it accepts any text before I update it (hit enter). Once I hit the enter, if text does not exist in the dropdown list give you error message. Which is perfectly what I want.

My struggling is, instead of typing the text, I would like assign the first letter of the text (with VBA code) to combo and then let user continue:

combo.SetFocus
combo.Text = "W"
combo.Dropdown

This gives me error message that item is not in the list. Can anyone help me for this? Thanks in advance!

 

[azfen]

Nobody wants to help?

 

[Frothingslosh]

From what you described, it sounds like you have 'limit to list' set to yes, and 'W' isn't in the list. Ergo the error message.

 

[azfen]

Yes, I would like to keep limit to list to Yes. 'W' will be the first letter of drop down list item.