Get second column contents of selection in Combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo on a form with 2 columns; I need to copy the second column
contents of the selected item in cboEditLinkTitle into the text box
tbxEditLinkStatus.

I placed the following into the combo's On_Change event code, but I get a
Type mismatch; the data is text...

Me.tbxEditLinkStatus.Value = Me.cboEditLinkTitle.Value(0, 0)

Can someone please tell me what I'm doing wrong/correct my code?

Thanks much in advance.
 
Try

Me.tbxEditLinkStatus = Me.cboEditLinkTitle.Column(1)

Note: the column number start with 0, so in my example I assumed that you
want the second column
 
Back
Top