Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    14

    Unanswered: List Box Question

    I have a list box that has two colums..."Account Number" and "Account Name".

    I also have two text boxes...one that holds the "Account Number" once selected in the list box. The other text box is suppose to hold the "Account Name"...but I can't figure out how.

    So, How should I go about populating the two text boxes with the item selected in the list box?

    Thanks.
    Chaci

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Oh my ... (Assuming a simple list box):

    TextBox1.Value=ListBox1.Column(XXX,ListBox1.ListIn dex)
    TextBox2.Value=ListBox1.Column(XXX+1,ListBox1.List Index)

    Next question ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    even simpler:

    textbox1 = listbox1.column(0)
    textbox2 = listbox1.column(1)

    ....assuming there are only those two columns in your listbox

    izy
    currently using SS 2008R2

Posting Permissions

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