Checkbox on database

[tigger]

Hi there

I'm now using Microsoft Access and i have a column called VT. I stored it into a variable called vibrotactile.

vibrotactile = ds.Tables("maskingSimulator").Rows(s).Item("VT")

The problem is the column contains checkboxes. If my VT column is not checked, it will carry out Case 1. Else, if my VT column is checked, it will carry out Case 2. How do i put it into codes? I tried to put 'if vibrotactile = false' and 'if vibrotactile = true'. But it doesn't seem to work. How do i go about it?

If vibrotactile = False Then
      'Case 1
      acTestEarThreshold = acTestEarThreshold
      End If

                If vibrotactile = True Then
                'Case 2
                        If acTestEarThreshold <= 20 Then
                        acTestEarThreshold = acTestEarThreshold

                        ElseIf acTestEarThreshold > 20 Then
                        acTestEarThreshold = 20
                        End If
                End If