checkboxes in visual basic

i am using visual basic 2005 express edition; and still a newbie since it only introduced this year. i have a database. my form had checkboxes. now, i am using odbc connection..using insert into statement..my question is, how do i get the value of the checked checkboxes and insert them in my table using that insert into statement? how do i include those values to my other fields? please help me out of here. i know, this is just a simple question but i am not that familaiar with visual basic. any help will be highly appreciated. thank you.

 

Something like this?

Code:

Dim i As String
If CheckBox1.Checked = True Then

i = "sql something or other here"

'SQL code to insert value of i (whatever it is you made it)

End If