vb sql problem

This code does not like the field name Second at the very bottom. Is there a way around this? Is there something to put around it to make it accept it?


MySQL = "Update rFormResults set ClinicCity ='" & txtClinicCity.Text & _
"', ClinicState = '" & txtClinicState.Text & _
"', School = '" & txtSchool.Text & _
"', HeadCoach = '" & txtHeadCoach.Text & _
"', Address = '" & txtAddress.Text & _
"', City = '" & txtCity.Text & _
"', State = '" & txtState.Text & _
"', ZipCode = '" & txtZip.Text & _
"', Phone = '" & txtPhone.Text & _
"', total = '" & txtTotal.Text & _
"', Ccard = '" & txtCardType.Text & _
"', CCnumber = '" & txtCCNumber.Text & _
"', CCexpiration = '" & txtCCExperation.Text & _
"', Attendees = '" & txtAttendees.Text & "', CCaccepted = '" & cmbAccepted.Text & _
"', Attendee_1 = '" & txtAttendee1.Text & "', Attendee_2 = '" & txtAttendee2.Text & _
"', Attendee_3 = '" & txtAttendee3.Text & "', Attendee_4 = '" & txtAttendee4.Text & _
"', Attendee_5 = '" & txtAttendee5.Text & _
"', Attendee_6 = '" & txtAttendee6.Text & "', Attendee_7 = '" & txtAttendee7.Text & _
"', Attendee_8 = '" & txtAttendee8.Text & "', Attendee_9 = '" & txtAttendee9.Text & _
"', Attendee_10 = '" & txtAttendee10.Text & "', Attendee_11 = '" & txtAttendee11.Text & _
"', Attendee_12 = '" & txtAttendee12.Text & "', Attendee_13 = '" & txtAttendee13.Text & _
"', Attendee_14 = '" & txtAttendee14.Text & "', Dup = '" & chkDup.value & _
"', Reason = '" & txtReason.Text & "', Second = '" & txtAddress2.Text & _
"' where ID = " & Text1.Text

Try putting the table name in front of the field name. For example:

[My Table].Second =

If this fails, perhaps you could post back the error text that you are getting so that we may help you further.

Hope this helps.