So I can make logic decisions on fields (see red text below):
Code:
'SQL to find the entry/division combo that is passed into this function
strSQL = "SELECT * FROM tblDivisionDetails " & _
"WHERE (((tblDivisionDetails.DivisionNo)=" & slngDivisionNo & ") AND " & _
"((tblDivisionDetails.ShowDetailsID)=" & slngShowDetailsID & "));"
Set rst = New ADODB.Recordset
With rst
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenKeyset 'Allow forward and backward movement in recordset
.LockType = adLockOptimistic 'Lock record after Update method is issued
.Open strSQL
If .BOF And .EOF Then
.Close
Set rst = Nothing
Exit Sub
End If
'the only time all 3 of the below variables would be true is if the user wants to delete the entire
'division from tblDivisionDetails
If sblnA And sblnB And sblnC Then
'if the entry is marked as having exhibited in any class in this division then provide the
' user with a strong warning and give them the option of selecting Yes - delete record or
' No - do not delete record
If !ExhibitedA Or !ExhibitedB Or !ExhibitedC Then
But if I tried:
Code:
me.checkboxOnSomeForm = !ExhibitedA
(ExhibitedA is a Yes/No field in that table.) it would fail? Interesting!
Red text did not show but tags are there.