Cascade of 3 or more ComboBoxes

[tomullus]

Hi,

I'm having difficulty with making a cascade of more than 2 combo boxes. Let's say that my Database has a single table (let's call it TableX) containing the following columns: Category, Group, Subgroup, Information. I want to have 3 combo boxes; the first filtering the second and the second filtering the third.

The first combo box has the following rowsource:

SELECT DISTINCT TableX.Category FROM TableX;

and an after update event:

Private Sub Combo1_AfterUpdate()
Me!Combo2.Requery
End Sub

Now for the second Combobox:
SELECT DISTINCT TableX.Category, TableX.Group FROM TableX WHERE (((TableX.Category)=[Forms]![MyForm]![Combo1]));

Up to this point everything works as expected, the third combo box doesn't.
I've given it the following rowsource (also added an afterupdate event to combo2):

SELECT DISTINCT TableX.Category, TableX.Group, TableX.Subgroup
FROM TableX
WHERE (((TableX.Category)=[Forms]![MyForm]![Combo2]) AND ((TableX.Group)=[Forms]![MyForm]![Combo2]));

I don't know if I've made a mistake but the third combobox is always blank. The "AND ((TableX.Group)=[Forms]![MyForm]![Combo2]))" part seems to be the problem, because when i lebae the rowsource as:

SELECT DISTINCT TableX.Category, TableX.Group, TableX.Subgroup
FROM TableX
WHERE ((TableX.Category)=[Forms]![MyForm]![Combo2]);

the combobox works (but obviously doesn't filter how I need it to).



Any help would be greatly appreciated.

[RuralGuy]

Are the two ComboBoxes bound to numeric fields? You do realize that you do not need to go through the Forms collection to reference the controls on the corrent form, right?

[tomullus]

No, the comboboxes are not bound to numeric fields. But the first and second comboboxes work properly no matter what type of data they are bound to. I checked what would happen if I chaned the columns to the numeric data type ,but the problem stays the same.

I honestly don't understand what do you mean by "going through the forms collection to reference the controls on the current form". Could you be more clear/specific? Sorry for being a dimwit.

Thanks for the reply.

EDIT: I fixed it. Issues with column count and bound column. Silly me. Thanks.

[RuralGuy]

[Forms]![MyForm]![Combo2]
...can be expressed as...
Me.Combo2

[RuralGuy]

Is TableX.Category a text field or a numeric one?