I even tryed to change the insert statement around to this....
sSql = "INSERT INTO DEPENDENTS(DEPEND_ID, DEPEND_ASSOC_ID, DEPEND_FNAME,DEPEND_LNAME, DEPEND_DOB, DEPEND_AGE, DEPEND_RELATE_TYP) VALUES ('" & cboAssociate2.Value & "','" & cboAssociate2.Value & "', '" & txtFirstName.Value & "', '"...