Help

[zarifin99ska]

on Microsoft Access database i create tables named John , Philip and William.
on Form1, i have datagridview1 which show those tables on database.
when i click one of them,i pass it into a textbox1 on Form2. for example i pass John into textbox1 and here is my code (i hope you all understand):

Form2.textbox1.Text = DataGridView1.CurrentRow.Cells(0).Value.ToString

but i also have datagridview2 on Form2.
there will be three column for datagridview2
How to insert John's data or the other(according to textbox1) from database into datagridwiew2?
i use

Private Sub textbox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles textbox1.TextChanged

for your information, the column name for those three table(John, Philip, and William) are customername, custphonenum, and custaddress.

i hope u all understand because Enlish is not my primary language.
Thanks.