Select value in Combo box using VB

[Guest]

How can I select an item in a combo box using VBA. I know what the bound
value should be but don't know what row that bound value is in the combo box.

Basically, I added a new item to the combo box and want to show the newly
added item after a requery. Is there a way to do this? thanks in advance.
Samantha

 

[Ken Snell [MVP]]

Just set the Value of the combo box:

Me.Combobox.Value = "Your new value"

 

[Guest]

It works! thanks Ken.

Just set the Value of the combo box:

Me.Combobox.Value = "Your new value"