Tjekke felter før valg af sql

Hejsa

Jeg har brug for at tjekke hvilket felt der er valgt (Checkboxe) inden min ASP vælger sql-statement (INSERT INTO...).

Jeg kan bare ikke få det til at virke. Min kode ser sådan ud:

Select Case Request.QueryString(\"action\")

Case \"save\"

Dim sql, sql1

Set Connect = Server.CreateObject(\"ADODB.Connection\")
Connect.Open \"jupiter\"

If Request.Form(\"option1\") = \"checked\" Then
    sql = \"INSERT INTO Quiz_svar (Quiz_id, E_mail, Country, Answer) VALUES (\"&\"\'\"&Request.Form(\"quiz_id\")&\"\', \'\"&Request.Form(\"e_mail\")&\"\', \'\"&Request.Form(\"country\")&\"\', \'\"&Request.Form(\"option1\")&\"\')\"
    COnnect.Execute(sql)
End if

If Request.Form(\"option2\") = \"checked\" Then
    sql = \"INSERT INTO Quiz_svar (Quiz_id, E_mail, Country, Answer) VALUES (\"&\"\'\"&Request.Form(\"quiz_id\")&\"\', \'\"&Request.Form(\"e_mail\")&\"\', \'\"&Request.Form(\"country\")&\"\', \'\"&Request.Form(\"option1\")&\"\')\"
    COnnect.Execute(sql)
End if

If Request.Form(\"option3\") = \"checked\" Then
    sql = \"INSERT INTO Quiz_svar (Quiz_id, E_mail, Country, Answer) VALUES (\"&\"\'\"&Request.Form(\"quiz_id\")&\"\', \'\"&Request.Form(\"e_mail\")&\"\', \'\"&Request.Form(\"country\")&\"\', \'\"&Request.Form(\"option1\")&\"\')\"
    COnnect.Execute(sql)
End if

If Request.Form(\"news\") = \"checked\" Then
    sql1 = \"INSERT INTO Jupiter_club_dk (E_mail, Land) VALUES (\"&\"\'\"&Request.Form(\"e_mail\")&\"\', \'\"&Request.Form(\"country\")&\"\')\"
    Connect.Execute(sql1)
End if

Connect.Close
Set Connect = Nothing

Response.Redirect(\"quiz_ok.asp\")

End Select

Håber der er nogen der kan hjælpe!