Grab data from unbound column of combo box

[jlrrush]

I have a combo box that contains id, first name, and last name, where id is the bound column. In a later form I want to populate a name field using the first and last name of the record selected in the combo box. I would like to use the setvalue function in a macro but can't figure out how to grab the data from the second column of my combo box.

 

[smedvid]

I typically use AfterUpdate Event of Combo-box...

Private Sub LoanCommissCategoryID_AfterUpdate()
Me.CompPlanType.Value = Me.LoanCommissCategoryID.Column(1)
End Sub

Where LoanCommissCategoryID is a Combo Box with 4 fields. Note: in Combo-boxes, the first position is denoted with a zero (0). Therefore in my example, I am setting CompPlanType to the second column item in the combo-box. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[jlrrush]

Thank you that worked perfectly!