G
Guest
I am currently trying to create a cascading combo.
The first table is called "Dept" and has two columns: "categoryID" and "Dept".
The second table is called "Subdept" and has three columns: "categoryID",
"Dept" and "Subdept".
In the first combo box I have "dept" and the second combo box I have "dept"
and "subdept".
The first combo box is called "Dept" and the row source is:
SELECT [Dept].[Dept] FROM Dept;
The second combo box is called "Subdept" and the row source is:
SELECT [Subdept].[Subdept] FROM Subdept WHERE
((([subdept].[dept])=[Forms]![Form1]![dept]));
Two problems:
1) Regardless of which first option I pick, the list in the 2nd box remains
the same
2) Any of the options in the 2nd box can't be chosen.
ideas?
cheers in advance.
The first table is called "Dept" and has two columns: "categoryID" and "Dept".
The second table is called "Subdept" and has three columns: "categoryID",
"Dept" and "Subdept".
In the first combo box I have "dept" and the second combo box I have "dept"
and "subdept".
The first combo box is called "Dept" and the row source is:
SELECT [Dept].[Dept] FROM Dept;
The second combo box is called "Subdept" and the row source is:
SELECT [Subdept].[Subdept] FROM Subdept WHERE
((([subdept].[dept])=[Forms]![Form1]![dept]));
Two problems:
1) Regardless of which first option I pick, the list in the 2nd box remains
the same
2) Any of the options in the 2nd box can't be chosen.
ideas?
cheers in advance.