Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Location
    The Hague, Netherlands
    Posts
    95

    Unanswered: Two Columns in on dropdown

    Hi,

    How do I set the rowsource of a dropdown to 2 columns in stead of one? Setting number of columns to 2 and then assigning something like the next statement doesnt work:

    ChOutlets.RowSource = "SELECT [tblmain].[outlet],[tblmain].[telnr] FROM [tblmain] WHERE [tblmain].[kamernrs] = " & ID

    (for the record, 1 column with ChOutlets.RowSource = "SELECT [tblmain].[outlet] FROM [tblmain] WHERE [tblmain].[kamernrs] = " & ID DOES work ;-))

    ---EDIT----
    Yes it does, I had a typo nevermind...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you need to set the number of columns to be displayed AND set the column widths

    if you wanted to display column 2 only you would use a column width of 0;2.5cm, or 0,1" for the metrically challenged

  3. #3
    Join Date
    Feb 2005
    Location
    The Hague, Netherlands
    Posts
    95
    Quote Originally Posted by healdem
    you need to set the number of columns to be displayed AND set the column widths

    if you wanted to display column 2 only you would use a column width of 0;2.5cm, or 0,1" for the metrically challenged
    Not entirely true, I didnt set the widths at first but then it just divides the space used, it's not that columns are not shown... But setting the width is idd a nice thing to know to design it a bit better

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    So you have set the number of columns to 2, adjusted the display widths and it doesn't work?

    what are you seeing?

  5. #5
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Are you trying to have both columns bound or just be able to view both columns ?
    Darasen

Posting Permissions

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