Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: I have a cbo with 3 columns i would like to get the value from the 2nd column

    I have a cbo with 3 columns i would like to get the value from the 2nd column of the row that is selected on the after update event.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    whatIwantIs = me.mycomboIsCalledThis.Column(1)
    ...index is zero-based: 0,1,2,3,4.......

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    The bound column value can be accessed using
    Code:
    selectedValue = Me.myListBox.Value
    Assuming this is single selections only...

    You can then access your column values using
    Code:
    Me.myListBox.Column(zeroBasedColumnNumber, selectedValue)
    George
    Home | Blog

  4. #4
    Join Date
    Oct 2003
    Posts
    233
    excellent, thanks guys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •