This thread is for discussions of Basic ADODC Example.

hey im new in VB and i downlaoded your code, and i wonder if you could help me on my baby thesis.My problem is just how to edit the records on my database using a command button.Here is my first form:

http://i69.photobucket.com/albums/i70/lhouwhie/form1.gif

When i click the "Edit" button the following form loads:

http://i69.photobucket.com/albums/i70/lhouwhie/form2.gif

Then when o click on the "Save" button nothing happens, when i go back to the dirst form the records just stays the same.

Here's my code for the "Save" button (i haven't put trappings yet):

Private Sub cmdsave_Click()
Adodc1.Refresh
Adodc1.Recordset.Fields("Firstname") = txtfname.Text
Adodc1.Recordset.Fields("Lastname") = txtlname.Text
Adodc1.Recordset.Fields("Address") = txtaddress.Text
Adodc1.Recordset.Fields("ContactNumber") = txtcnum.Text
Adodc1.Recordset.Fields("Birthdate") = txtbirth.Text
Adodc1.Recordset.Fields("UserLevel") = cmblvl.Text
Adodc1.Recordset.Fields("Gender") = cmbgen.Text
Adodc1.Recordset.Update
Adodc1.Refresh
End Sub

thanks in advance and God Bless

 How can i search a string inlcuding '  example   'John