Printable View
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.
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
That helped but now when I change my selection the same date stays in the text boxes. Any suggestions?