Can someone else put a pair of eyes on this? I've been programming for too long I think, and something obvious is missing, but can't put a finger on it..
The following line is giving me a syntax error in expression:
Code:
rsStockIn.FindFirst ("[pID] = " & !pID & " AND [pExhausted] = 0")
Here is part of the module that is relevant:
Code:
rsStockIn.MoveLast
rsStockIn.MoveFirst
rsStockOutTEMP.MoveLast
rsStockOutTEMP.MoveFirst
With rsStockOutTEMP
Do Until .EOF
While sItemRecorded = False
rsStockIn.MoveFirst 'PREP FOR FIND RECORD COMMAND
rsStockIn.FindFirst ("[pID] = " & !pID & " AND [pExhausted] = 0")
'''''MORE CODE'''''''
Wend
sItemRecorded = False
.MoveNext
Loop
End With
The !pID field is a LONG and Exhausted is a BOOLEAN. I ran on a test with a simple recordset with the exact same line of syntax replacing !pID with a LONG variable that was declared and it worked fine and found the record. What am I missing guys? Thanks for any help!