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(ByVal sender As System.Object, ByVal e As System.EventArgs) 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_PLANTableAdapter1.Fill(Me.AutodbDataSet1.T EST_CASE_LINK, TEST_PLANComboBox.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_PLANTableAdapter.FillBytestplan(Me.AutodbD ataSet.TEST_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_Leave" function or can you help me with the code please.
Thanks