got a problem "somewhere",
...and starting to second guessing myself
just to be certain, the below code does check that there is at least one single record in the table where both of the conditions are true;
(not that there is at least one record that satisfies one criteria, and another (not necessarily same record) that satisfies the other criteria...
Code:
Dim vCNote_ID as Inteeger
Dim vCNote_Descript As String
dim vCNote_ChxBox_Field as String
Dim vCNote_CntEOS As Integer
Dim vCNote_CntReqd As Boolean
vCNote_Descript = DLookup("[CNote_Title]", "tblCNotes_EOS", "[CNote_ID]= " & vCNote_ID)
vCNote_ChxBox_Field = DLookup("[CNote_chkbox_Field]", "tblCNotes_EOS", "[CNote_ID]= " & vCNote_ID)
vCNote_CntEOS = DCount("[CNote_ID]", "tbeCoordinationNotes_EOS", "[CNote_ID]= " & vCNote_ID)
vCNote_CntReqd = DCount("[Type]", "tbeFixtureTypeDetails", "[ContractorToCoordYN] And [" & vCNote_ChxBox_field & "]") > 0
with appreciation in advance,
mark