use combobox to populate the form

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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion