I have a Form that does a complex import/convert from an Excel Spreadsheet into a Table (well, a set of tables really).
At one point, I try setting the following WhereCondition on a Recordset:
Code:
strCriteriaRawb = "[PatParent]='" & rstPattern("Pattern") & "' And " & _
"[PatUseOffset]=" & rstBoMTable("BomUseOffsets")
rstPatCrossRef.FindFirst strCriteriaRawb
For some reason, No matter what rstBoMTable("BomUseOffsets") results in, the string strCriteriaRawb always ends in "[PatUseOffset]=False"!
I've stepped through the code and everything seems to be working perfectly except that one statement, anyone know what's going on?
P.S.
To help explain, I've attached a couple of Screenies of me stepping through the code.