Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

use combobox to populate the form

gsanghvi20gsanghvi20 Posts: 2Member
Hi guys,
I am new at VBA programming.
I have a form with text boxes and one combo box which has the Primary key values as a drop down list. Now, on the basis of the selection in the combo box I want to populate the values in the text boxes. Please let me know how am I supposed to do this.
Thanks,
gsanghvi20

Comments

  • BarkeeperBarkeeper Posts: 335Member
    : Hi guys,
    : I am new at VBA programming.
    : I have a form with text boxes and one combo box which has the
    : Primary key values as a drop down list. Now, on the basis of the
    : selection in the combo box I want to populate the values in the text
    : boxes. Please let me know how am I supposed to do this.
    : Thanks,
    : gsanghvi20

    Private Sub ComboBox_Change()

    Select Case ComboBox.Text

    Case "1"
    Text1.Text="Entry 1"
    Case "2"
    Text2.Text="Entry 2"
    .
    .
    .

    End Select
    End Sub
    ------------------------------------------
    Only stupidity of mankind and the universe
    are infinite, but i'm not sure concerning
    the universe. A. Einstein
Sign In or Register to comment.