Autopopulate text boxes after selecting a combo box entry

[jw01]

I have a form in which there is one combo box and three text boxes:

Combo Box:
-> Item A
-> Item B
-> Item C

TextBox1:
TextBox2:
TextBox3:

Once an Item is selected from the combo box, the text boxes are autopopulated with the respected fields which link to the items in the combo box.

Its getting the combo and the text boxes from a data base.

Can someone guide me as how to do that?

Write now I have a combo Box with all the items but I dont know how to link the text box fields to the items in the combo box.

So the text boxes 1, 2 and 3 are filled out on selecting an item from the combo box



Thank you

[SanjuMtr]

I have a form in which there is one combo box and three text boxes:

Combo Box:
-> Item A
-> Item B
-> Item C

TextBox1:
TextBox2:
TextBox3:

Once an Item is selected from the combo box, the text boxes are autopopulated with the respected fields which link to the items in the combo box.

Its getting the combo and the text boxes from a data base.

Can someone guide me as how to do that?

Write now I have a combo Box with all the items but I dont know how to link the text box fields to the items in the combo box.

So the text boxes 1, 2 and 3 are filled out on selecting an item from the combo box



Thank you

Yes it can be achieved easily.
Now I have Just Give u the Hints.ok First Try Yourself. if not possible then i will
give u the Details Code.

1)First Populate the Combo in Form Load event.
2)Now write code(searching desire recor) in combo_change event.
a) select the fields that u want to display in textbox through recordset filter by combo.text
b) if recordset recordcount >0 i.e if u will find desire record then show it in the
corrosponding textbox.

[jw01]

Yes it can be achieved easily.
Now I have Just Give u the Hints.ok First Try Yourself. if not possible then i will
give u the Details Code.

1)First Populate the Combo in Form Load event.
2)Now write code(searching desire recor) in combo_change event.
a) select the fields that u want to display in textbox through recordset filter by combo.text
b) if recordset recordcount >0 i.e if u will find desire record then show it in the
corrosponding textbox.

Following is the code I have:

Public Class Form1

'Loads the names of the active cycles in the combobox
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
'TODO: This line of code loads data into the 'AutodbDataSet1 .TEST_PLAN' table. You can move, or remove it, as needed.
' This is the query that is autopopulated
Me.TEST_PLANTab leAdapter1.Fill (Me.AutodbDataS et1.TEST_CASE_L INK, TEST_PLANComboB ox.Text)
'TODO: This line of code loads data into the 'AutodbDataSet. TEST_PLAN' table. You can move, or remove it, as needed.
' This is the query that loads the cycles
Me.TEST_PLANTab leAdapter.FillB ytestplan(Me.Au todbDataSet.TES T_PLAN)

End Sub
End Class

So right now there are multiple enteries in the combo box but the text fields just point to the first one on the database. And dont change when a different entry is selected in the combo box.

Should it be something like "textchange in combo box" then autopopulate the fields with the appropriate items that link to the combo box.

I am new to VB so is it the "cboName_Le ave" function or can you help me with the code please.

Thanks