A kinda easy database question

[ttingen]

Dim sTableName As String

Select Case CheckBoxArray
    Case CheckBoxArray(0)
        sTableName = "First_Table"
    Case CheckBoxArray(1)
        sTableName = "Second_Table"
    Case CheckBoxArray(2)
        sTableName = "Third_Table"
    'and so on
End Select

'Then use the table name in you SQL statement
'to insert records into that table