Parameter through for in Crosstab Query

[polkev]

I'm trying to pass a parameter to a crosstab query in Access 2007.

my SQL is:

TRANSFORM IIf(Count([idsTaskID]) Is Null,0,Count([idsTaskID])) AS NullToZero
SELECT tblSharpTasks.strMedium AS [Communication Method]
FROM tblSharpTasks
WHERE tblSharpTasks.datDateCompleted >=[Forms]![frmTesting123]![txtStratDate]
GROUP BY tblSharpTasks.strMedium

PIVOT Format([datDateCompleted],"mmm yyyy");

when i run the query I get an error saying that "[Forms]![frmTesting123]![txtStratDate] is not a valid field name or expression." To confirm, frmTesting123 is the form name, and txtStratDate is the control. What am I doing wrong?

 

[polkev]

Solved it on my own. did not have parameter clause.