Zydeceltico
Registered User.
- Local time
- Today, 12:49
- Joined
- Dec 5, 2017
- Messages
- 843
Is anyone able to find the syntax error in this code? :
I can't find it and it's driving me nuts.
Thanks!
Tim
Code:
Set tmpRS = CurrentDb.OpenRecordset ("SELECT tblParts.Part_ID, tblParts.PartType, tblParts.PartDWG " & _
"FROM tblParts" & _
"WHERE (((tblParts.Part_ID)=intPartID))" & _
"GROUP BY tblParts.Part_ID" & _
"HAVING ((tblParts.Part_ID = ' "& Me.txtPartType_FK & " ') " & _
"And (tblParts.PartType = ' "& Me.txtPartName & " ' ) " & _
"And(tblParts.PartDWG = ' " & Me.txtPartDrawing " '))")
I can't find it and it's driving me nuts.
Thanks!
Tim