Selecting a combobox item with VBA

[tylerg11]

I am trying to use VBA to select a combobox value. My code can place the value in the combobox, but then I have to open the list and select the value manually in order for it to really be selected. Just wondering if there is some sort of property that actually selects the item, instead of just placing the value in that combobox control.

[TG_W]

If you're using VBA to populate, why not make the Combo Box a Text Box? If you still want to give users the option of the box, maybe you can have it be a different filtration code.

[tylerg11]

This won't work in my situation.

[TG_W]

Well, without much more detail, I'm afraid I can't be of much more help. Sorry.

[TG_W]

I'll take one more stab at it for now - what about adding Me.Requery after updating the value?

[tylerg11]

Neither Me.Requery or Me.Refresh work.

I figured out that ComboBox.ListIndex will do that trick. However, now I need to find out how to find the ListIndex if my value matches with the one I want to select in the dropdown.

[TG_W]

Ok, again, without knowing much more information, I don't think I can help much further. Sorry.