use combobox to populate the form - Programmers Heaven

Howdy, Stranger!

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

Categories

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.