L
LindaC
I have a Department field which looks up Divisions. A division only can
belong to a certain Department. I have a Department Table and a Division
table. On the form when I select a Department I only want the availabe
selections in the Division field to be those from that Department. In the
Division field I have the following formula but it is not working. I think
the problem is with the WHERE. Any ideas where I am going wrong?
"SELECT tblDivision.Division, tblArchive2.DepartmentID, tblArchive2.DivisionID
FROM (tblDepartment INNER JOIN tblDivision ON tblDepartment.DepartmentID =
tblDivision.DepartmentID) INNER JOIN tblArchive AS tblArchive2 ON
(tblDivision.DivisionID = tblArchive2.DivisionID) AND
(tblDepartment.DepartmentID = tblArchive2.DepartmentID)
WHERE (((tblDivision.DepartmentID)=([tblArchive].[DepartmentID])));
belong to a certain Department. I have a Department Table and a Division
table. On the form when I select a Department I only want the availabe
selections in the Division field to be those from that Department. In the
Division field I have the following formula but it is not working. I think
the problem is with the WHERE. Any ideas where I am going wrong?
"SELECT tblDivision.Division, tblArchive2.DepartmentID, tblArchive2.DivisionID
FROM (tblDepartment INNER JOIN tblDivision ON tblDepartment.DepartmentID =
tblDivision.DepartmentID) INNER JOIN tblArchive AS tblArchive2 ON
(tblDivision.DivisionID = tblArchive2.DivisionID) AND
(tblDepartment.DepartmentID = tblArchive2.DepartmentID)
WHERE (((tblDivision.DepartmentID)=([tblArchive].[DepartmentID])));