Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    4

    Unanswered: updating textbox from combobox selection

    can anyone help me with this:

    i have a combobox called 'combo1' and 2 textboxs called 'text1' and 'text2'.

    combo1 contains 'ID, lastname, firstname'. whenever i change/select a value in combo1, i want to populate text1 with lastname and text2 with firstname. the bound column for combo1 will be ID.

    mk

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    use the after update event to catch the change of the combobox and the column property to get the values of the other columns in the combobox.

    Code:
    private sub combo1_afterupdate()
        me.text1=me.combo1.column(1) 'lastname
        me.text2=me.combo1.column(2) 'firstname
    end sub

Posting Permissions

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