A
Alexey
Hi I am running the SQL query below in Access 2002/2003 without any issues,
but in Access 2007 it comes up with a 3139 Syntax error in the PARAMETER
clause.
Has anyone any idea what has changed in 2007?
Thanks
A
PARAMETERS [Forms]![frmStudentModules]![StudentModuleID] Long;
SELECT tblStudentModules.StudentModuleID, tblStudents.*, tblModule.Title AS
ModuleName, tblStudentModules.[Module Tutor], tblTutors.Email
FROM tblModule INNER JOIN ((tblTutors INNER JOIN tblStudents ON
tblTutors.TutorID = tblStudents.[Student Tutor]) INNER JOIN
tblStudentModules ON tblStudents.StudentID = tblStudentModules.Student) ON
tblModule.[Module Code] = tblStudentModules.Module
WHERE
(((tblStudentModules.StudentModuleID)=[Forms]![frmStudentModules]![StudentModuleID]));
but in Access 2007 it comes up with a 3139 Syntax error in the PARAMETER
clause.
Has anyone any idea what has changed in 2007?
Thanks
A
PARAMETERS [Forms]![frmStudentModules]![StudentModuleID] Long;
SELECT tblStudentModules.StudentModuleID, tblStudents.*, tblModule.Title AS
ModuleName, tblStudentModules.[Module Tutor], tblTutors.Email
FROM tblModule INNER JOIN ((tblTutors INNER JOIN tblStudents ON
tblTutors.TutorID = tblStudents.[Student Tutor]) INNER JOIN
tblStudentModules ON tblStudents.StudentID = tblStudentModules.Student) ON
tblModule.[Module Code] = tblStudentModules.Module
WHERE
(((tblStudentModules.StudentModuleID)=[Forms]![frmStudentModules]![StudentModuleID]));