Help!Hooking combo boxes to textboxes.

[VBAmateur]

I want to hook up 4 textboxes to a combo box so that when someone selects a choice in the combo it automatically sends further info on that selection into the textboxes next to it. For example, when they select a name in the combo I want it to fill in the address, phone, etc of that person into the textboxes. How can I connect that? Thanks.

[rod]

Find the combo box "CLICK" event and put some code, whatever you want your application to perform. Everytime you click or change the index of your combo box, this code will be executed.

e.g. if you have a combo box named MyCombo, then find the click event

Private sub MyCombo_Click()

TextBoxName.Text = MyTable("Name")
TextBoxAge.Text = MyTable("Age")
TextBoxSex.Text = MyTable("Sex")
TextBoxAddress.Text = MyTable("Address")

End Sub

[VBAmateur]

That helped but now when I change my selection the same date stays in the text boxes. Any suggestions?