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