I am having some big problems with this 'Invalid Bracketing of Name' error. I have looked on this forums and others for suggestions but everything suggested has not helped. Does anyone else have any ideas to resolve this?
Basically, I get the error on the line [Forms!fmnuReportSelect.cboSrvID] in this query:
PARAMETERS [[Forms]!fmnuReportSelect.[cboSrvID]] Long;
TRANSFORM Count(tblResponses.Rspns) AS CountOfRspns
SELECT tblSrvRspns.URN, 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.cboS rvID) AND ((tblResponses.RspnsID) Like [Forms]![fmnuReportSelect]![cboRespondant]))
GROUP BY tblSrvRspns.URN, tblQuestions.QstnID, tblQuestions.QstnLvl1, tblQuestions.QstnLvl2, tblQuestions.QstnLvl3, tblQuestions.QstnText, tblResponses.Rspns, tblQuestions.SrvID
PIVOT "Number of Responses" In ("Number of Responses");
This line appears twice but it seems to be the first one that is causing the problems. Whenever I go back into the query it has defaulted to this:
I had tried changing them around to see what works but must not have had one point where all of them had the same format. Now that I have made sure they all have the same style, i.e. Forms!fmnuReportSelect!cboSrvID, they work perfectly and are not reverting back to the horrible square brackets.