Results 1 to 2 of 2

Thread: Combo Box

  1. #1
    Join Date
    May 2004
    Posts
    7

    Unanswered: Combo Box

    Sorry to bug you lot but....

    I have a combo box pulling data from a table onto a from
    RowSourceType:Table/Query
    RowSource:MyTable

    and i want to pass the following data From MyTable columuns 2,3,6 into the 3 text boxes bellowi.e

    Combo Box:Name

    TextBox1=Columun2
    TextBox2=Columun3
    TextBox3=Columun6

    thank you and sorry if this doesnt make sense

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Bac83
    Sorry to bug you lot but....

    I have a combo box pulling data from a table onto a from
    RowSourceType:Table/Query
    RowSource:MyTable

    and i want to pass the following data From MyTable columuns 2,3,6 into the 3 text boxes bellowi.e

    Combo Box:Name

    TextBox1=Columun2
    TextBox2=Columun3
    TextBox3=Columun6

    thank you and sorry if this doesnt make sense
    TextBox1.Value=Name.Column(1,Name.ListIndex)

    Think you can handle the others?

    Hint: Combobox index offsets are zero based ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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