Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Selected column data (2007)

    Hello. I have a combo box on a form with several columns. When I select an item from the combo, I'm trying to set the ControlSource of a text box to the fourth column data (of the selected item). I'm using the AfterUpdate event of the combo box. What expression can I set the ControlSource of the text box to, to achieve this? Thanks, Andy.

  2. #2
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selected column data (2007)

    Actually, I've solved this using
    txtTest.ControlSource = "=" & cboTest.Column(3,cboTest.ListIndex)
    Bit sad though, answering my own question...
    Andy.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Selected column data (2007)

    >>> Bit sad though, answering my own question...

    I suppose its better than getting NO answer at all! <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    PS: At least you beat Hans to the answer... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> if anything, thats an achievement!
    Regards,
    Rudi

Posting Permissions

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