Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to work with an unbound column in a combo box. For some reason I have trouble every time I try to work with this.

    I have two columns in a combo box on a form. After I select an item I want the bound column (2) to fill in one textbox on the form and the unbound column (1) to fill in another textbox on the form.

    I can get the bound column (2) to fill in the "Team" textbox , but I can not get the unbound column (1) to fill in the "Sport" textbox.

    See attached sample database.

    What am I doing wrong?

    Thanks.

    Paul
    Attached Files Attached Files

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    The Code should be

    Code:
    =[CboFallSports].[column](0)
    Although on the Properties Page it uses Column Numbers from 1
    In the .Columns(n) property they start from 0

    So Column 1 is =[CboFallSports].[column](0)
    Column 2 is =[CboFallSports].[column](1)
    Andrew

  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Now it makes sense!

    Thanks so much.

    Paul

Posting Permissions

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