CODEWITHSUNDEEP
ms-accessvba
DasPete
DasPete

Reputation: 851

Set combobox with second column

I have a combobox with two columns, description and ID respectively. The ID column is hidden. Sometimes the combobox value is selected programatically, I would like to be able to make this selection using the ID column. Can anyone tell me how to do that?

Thanks

Upvotes: 0

Views: 324

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

If the ID column is the bound column, you can simply say:

 Me.MyCombo=1

Where 1 is an ID in the row source.

Upvotes: 1

Related Questions