Fill In

G

Guest

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])));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change value based on combobox not working 1
Form Lookup From Query - Display different from data in table 1
Restricting Access to Certain Information 3
Table Design 4
Easy Fill In but I don't get it 2
Cascading combo box code error 3
Dependent combo boxes issue 1
Combo box to limit selection based on current record in form 1

Top