Recordset Syntax Problem

[missymarie1014]

I have this code trying to retrieve data into a recordset. The problem is in the last section. The field 'InactiveProduct' is located in the BatchTemplateDetailQuery and is a true/false field. I am not sure how to write the code for that piece. Any help would be appreciated.

Set rs = CurDB.OpenRecordset("SELECT * from BatchTemplateDetailQuery WHERE" & _
(" TemplateID =" & Forms!CreateBatchFromTemplateForm!TemplateID) And (" InactiveProduct ='" & True & "'")

 

[JoeAtWork]

Don't put quotes around it, and clean up the placement of parenthesis

Set rs = CurDB.OpenRecordset("SELECT * from BatchTemplateDetailQuery WHERE" & _
" (TemplateID =" & Forms!CreateBatchFromTemplateForm!TemplateID & ") And (InactiveProduct = True)")

Joe Schwarz
Custom Software Developer

http://www.plandev.net