I have a big long insert statement that was used prior, I have shortened it just to test it.
str_pp_sql = "INSERT INTO PRIVATE_FINAL(lastname, firstname, pcn, month, cert, phyupin) VALUES('" & txt_pp_lname.Text & "','" & txt_pp_fname.Text & "','" & txt_pp_pcn.Text & "', '" & ddl_pp_month.SelectedValue & "' ,'" & txt_pp_ptcert.Text & "','" & txt_pp_phyupin.Text & "')"
I added a drop down list with the months as a collection. i have added the month field to table and have pcn, month, and cert as primary keys. I have used this exact insert statement in access and it works. The only different thing I did was use values instead of variables, (ie., "Doe","John",etc.). Everytime I run the web application, I get an error message, syntax error in insert into statement. I don't know why this won't work.