Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    280

    Unanswered: How do you display a specific data in a combo box..

    by hardcoding in VBA. In the combo box, I want to display the information with the data or value I have.

    ex. for combo box display.
    row1: A
    row2: B
    row2: C

    How do I display the third row with VBA? I have try the "listindex" and it didn't work..

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by lansing
    by hardcoding in VBA. In the combo box, I want to display the information with the data or value I have.

    ex. for combo box display.
    row1: A
    row2: B
    row2: C

    How do I display the third row with VBA? I have try the "listindex" and it didn't work..
    MyCombobox.Value=MyCombobox.Column(<BoundColumn>,2 )

    whatever the bound column number is ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Apr 2003
    Posts
    280
    Thanks! I never thought of using the value property. I keep thinking of rows or listindex..

  4. #4
    Join Date
    Apr 2003
    Posts
    280
    what is the 2 for after boundcolumn?

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by lansing
    what is the 2 for after boundcolumn?
    The Column property has 2 parameters: Column #, Row #
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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