Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: Passing through values from individual columns in Listboxes

    If I have a listbox with 4 columns displayed. Is it possible to pass the values from each of the columns to text fields on another form.
    I can do it from 2 listboxes with only one column using the following code just wondering what I am missing

    Me.TextBox1 = Forms!formname.listbox1
    Me.TextBox2 = Forms!formname.listbox2

    I have tried

    Me.TextBox1 = Forms!formname.listbox1(0)
    Me.TextBox2 = Forms!formname.listbox1(1)

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Try:
    Code:
    Me.TextBox1 = Forms!formname.listbox1.Column(0)
    Me.TextBox2 = Forms!formname.listbox1.Column(1)
    Have a nice day!

Posting Permissions

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