Debugging help

[Buakaw]

Hi,


When I try to click on a query I get this error message:

Invalid bracketing of name '[Forms!fmnuReportSelect!cboSrvID]'

I compared the SQL code with the clean version (which runs without a bug) and there was no difference. I am at a loss of how to continue debugging this.

Can someone give me some tips on how I can debug things like this? Thanks.

This is the SQL code of the query.

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

[pbaldy]

I think it should be:

PARAMETERS [Forms]!fmnuReportSelect![cboSrvID] Long;

[Buakaw]

I think it should be:

PARAMETERS [Forms]!fmnuReportSelect![cboSrvID] Long;

Thanks, that seemed to do the trick. But I don't understand why because what I pasted was in the original clean copy and it works.

[pbaldy]

I've never seen it that way, but it wouldn't be the first time something like that surprised me. Glad you got it working in any case.