Help with basing Combo Boxes on other Combo Boxes

[Guest]

I have a form on which there are three Combo Boxes, which I am trying to make
dependent, ie the second Combo Box dependent of the first and the third on
the second. I have been able to get the second Combo Box to work with the
first by using the following statement as the Row Source: “SELECT
[Sub-committee Table].SubcommID, [Sub-committee Table].Subcommittee,
[Sub-committee Table].CommID WHERE ((([Sub-committee
Table].CommID)=Forms![Committee Update Form]!Committees)) ORDER BY
[Sub-committee Table].Subcommittee;â€.

When I try to use a similar statement to make the third Combo Box dependent
on this the one above it doesn’t work. The statement I used is, “SELECT
[Sub-committee Position Table].SubPositionID, [Sub-committee Position
Table].SubPosition, [Sub-committee Position Table].SubCommID WHERE
((([Sub-committee Position Table].SubCommID)=Forms![Committee Update
Form]!Subcommittee)) ORDER BY [Sub-committee Table].SubPosition;â€.

What am I doing wrong?

Thanks,

 

[Van T. Dinh]

Did you use Requery on the ComboBoxes?

See example in The Access Web:

http://www.mvps.org/access/forms/frm0028.htm

HTH
Van T. Dinh
MVP (Access)