What is wrong with this SQL WHERE clause

[bakershawnm]

Can anyone tell me what I am doing wrong with this WHERE clause and why I am getting "No value given for one or more required parameters" when I add the date portion?

"WHERE ((dbo_FnshPrtsLst.Drawing ='" & Me!Drawing & "') " & _
"AND (dbo_FnshLstPrts.Date_Extracted=#" & Me![Dt_Extrctd] & "#));"


Thanks much

 

[bakershawnm]

Sorry forgot to mention I am using Access 2007.

 

[bakershawnm]

man do I feel stupid now. transposed Lst and Prts on the date line.