SQL Parameters keyword?

[Buakaw]

Hi,


I'm trying to modify a sample database and came across this query:

PARAMETERS [[Forms]!fmnuReportSelect![cboSrvID]] Long;
TRANSFORM Count(tblResponses.Rspns) AS CountOfRspns
SELECT tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2, tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns, tblQuestions.SrvID
FROM tblQuestions INNER JOIN tblResponses ON tblQuestions.QstnID = tblResponses.QstnID
WHERE (((tblQuestions.SrvID)=[Forms]![fmnuReportSelect]![cboSrvID]) AND ((tblQuestions.QstnType)="Stat" Or (tblQuestions.QstnType)="Demo"))
GROUP BY tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2, tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns, tblQuestions.SrvID
PIVOT "Number of Responses" In ("Number of Responses");

However a syntax error is flagged by Access if I try to make any changes. It says:
"Syntax error in PARAMETER clause".

Does anyone know what's wrong with it? I suspect it's the name of the variable itself.

Thanks!

[ajetrumpet]

I suspect that PARAMETERS can't take form references. You need to put the name of the param in that place. that's the point of a parameter. If you want a pointer to a form's value somewhere, put it in the WHERE clause. that's where it belongs.