Displaying combo box value on form

[gmazza via AccessMonster.com]

Hey there,
Is there anyway to extract the value from a combo box?
For my combo box I have 2 fields, the first one being the id, the second one
being the value.
I have a separate unbound text box that I want to display the value from the
textbox.

When I put this code in my Change event on the combo box:
Text59 = cboCriteriaOptionValue

I am getting the id. How can I get the vlue displayed?
Thanks!

 

[Chegu Tom]

text59=me.cboCriteriaOption.column(1)

Column(0) is your first field in the combo box column(1) is the second field
etc

 

[gmazza via AccessMonster.com]

Thank you sir!

text59=me.cboCriteriaOption.column(1)

Column(0) is your first field in the combo box column(1) is the second field
etc

Hey there,
Is there anyway to extract the value from a combo box?

[quoted text clipped - 10 lines]

I am getting the id. How can I get the vlue displayed?
Thanks!