Combo Box second column (1 Viewer)

Gismo

Registered User.
Local time
Today, 20:04
Joined
Jun 12, 2017
Messages
548
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

error reading drive A:
Local time
Tomorrow, 01:04
Joined
May 7, 2009
Messages
9,872
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
Today, 20:04
Joined
Jun 12, 2017
Messages
548
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
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 18:04
Joined
Jul 9, 2003
Messages
11,784
Get Info from a Combo box - Nifty Access
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom