Hi, i'm new here but i'm having alot of trouble using the SQL functions to update stuff in my database.... the code is below can anyone here help out and tell me whats wrong with it please......

VB Code:
  1. Dim MyConn As ADODB.Connection

  2.     Dim MyRecSet As ADODB.Recordset

  3.     

  4.     

  5.     Set MyConn = New ADODB.Connection

  6.     MyConn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=MS Access Database;Initial Catalog=D:\Documents and Settings\christopher.lynch\Desktop\Manual Time And attendance\Manualrecords.mdb"

  7.     

  8.     MyConn.Open

  9.     MyConn.Execute ("UPDATE Manual SET '" & CmbClass.Text & "' = '" & CmbAttendance.Text & "' WHERE StudentName = '" & CmbStudent.Text & "'")

  10.         

  11.     

  12.     MyConn.Close

What is ment to happen is, I have thre combe boxes with selection. I what to select a name to alter, class for that name and whether the student is absent or present.....