I have a database with 20 fields/columns.

Normally when I generate the data with a form, all the 20 fields will appear on the table.

Now i want to use checkbox to allow user to choose which column to appear.

I have got this:

Code:
Private Sub genQuery()

sqlStr = "SELECT"
MsgBox sqlStr

If Me.[1] = True Then
        sqlStr = sqlStr & "
...