How-To: Select and Display Combo Box choice with VBA

[Stu]

How To: Using a value from another field I would like to display a certain
selection in a combo box. For example if a user selects 'X' then I would
like to display ITEM(3). What combo box properties/methods should I be using?

 

[Kinlye]

Use after update event on the item where the user selects "X".

 

[Stu]

My question wasn't about the event but what is the VBA code to select and
display a combo box choice.

 

[Douglas J. Steele]

Define "a certain selection in a combo box".

Does your ITEM(3) mean that you want the value of the third row of the combo
box?

Which column of the combo box does you want?

Assuming you want the value of the first value of the third row, you'd use
something like:

Me.NameOfComboBox.Column(0, 2)

(numbering starts at 0)

 

[Stu]

Thanks that got me on the right track. Here is what I was looking for:
Me.NameOfComboBox=Me.NameOfComboBox.Column(0, 2)
Case Closed.