How can I filter a Combo Box using another field in the same reco.

[Guest]

In a form I want to have two Combo Boxes, the first one contains "Main Group"
information and the second one contains the information of the "Subgroups" of
the "Main Group". I need that the sub Combo shows just the subgroup's items
for the selected main group in each line in Continious View of the form. It
does not work right.

Maingruop Table has two fields, MainGroupNo, MaingroupName.

Subgruop Table has three fields, MainGroupNo, SubgroupNo and SubgroupName.

In the "InputForm" I have created two Combo Boxes, "cmbMainGroup" and
"cmbSubGroups".

In the RowSource of the cmbSubgroup I have defined a query using all three
Subgroup fields and in the Criteria field of the MainGroupNo I entered
"[Forms]![InputForm]![cmbMainGroup]" intending to have the list of the
subgroup items for each maingroup selected in cmbMainGroup. It doesn't work
as intende and the cmbSubGroup shows the same listfor all lines of the
InputForm! I am wondering if I am making a major mistake in defining these
combo boxes?

Thank for any help I receive

Ken Ghashghaei

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm