Combo Box second column (1 Viewer)

Gismo

Registered User.
Local time
Tomorrow, 00:34
Joined
Jun 12, 2017
Messages
1,298
Hi,

how do I extract the second value from combo box using expression builder?

i tried # Me.YourComboBoxNameHere.Column #

i am using a text box to display the second value from combo box
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:34
Joined
May 7, 2009
Messages
19,169
add code to the Combo's AfterUpdate event:

private sub comboName_AfterUpdate()
'combo/listbox is zero (0) based
'so to refer to column1, you use Column(0)
'
Me.textbox1 = comboName.Column(1)
end sub
 

Gismo

Registered User.
Local time
Tomorrow, 00:34
Joined
Jun 12, 2017
Messages
1,298
add code to the Combo's AfterUpdate event:

private sub comboName_AfterUpdate()
'combo/listbox is zero (0) based
'so to refer to column1, you use Column(0)
'
Me.textbox1 = comboName.Column(1)
end sub
works great, thank you
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:34
Joined
May 7, 2009
Messages
19,169
youre welcome!
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 22:34
Joined
Jul 9, 2003
Messages
16,245
Get Info from a Combo box - Nifty Access
 

Users who are viewing this thread

Top Bottom