Cascading Combo Boxes

[Jason Wills]

Hi all,

Just figured out how to do cascading combo boxes (bit of a novice) however,
i would like to know if it is possible to do this over three or more combo
boxes - i have only done it with two, and can't get it to work with three,
if so, how?

thanx in advance

J

 

[Van T. Dinh]

Same principle.

The RowSource of the 3rd ComboBox should be a Parametrised Query with some
form of the value of the 2nd ComboBox being the Parameter value.

Use the AfterUpdate Event of the 2nd ComboBox to requery the 3rd ComboBox.

See The Access Web:

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

 

[Guest]

.... but try to do it in continuous form... it wont work.. i need exactly this solution... but without success

 

[Van T. Dinh]

More complex in ContinuousFormView since what you see is many instances of
the *same* ComboBox (and therefore only ONE RowSource) while you need
*different* RowSources for the different instances of the ComboBox.

A work-around is to use *two* ComboBoxes, says, "cboUnfiltered" and
"cboFiltered". Use an unfiltered RowSource for the cboUnfiltered (every
possible values in this RowSource) and use a filtered / parametrised
RowSource for the cboFiltered.

Size the 2 ComboBoxes to be exactly the same and bring cboUnfiltered in
front of cboFiltered. Use the cboUnFiltered_GotFocus Event to set the Focus
onto the cboFiltered.

This way, in the non-current rows (and the current row when the Focus is on
some other Control), the user will see the cboUnfiltered which will display
correctly (since all possible values are in the RowSource). As soon as the
user put the Focus into cboUnfiltered, the GotFocus Event will send the
Focus to the cboFiltered. This will make the cboFiltered visible and the
user can only select a value from the *filtered* list.

--
HTH
Van T. Dinh
MVP (Access)

... but try to do it in continuous form... it wont work.. i need exactly

this solution... but without success

 

[Guest]

but in previuos "line" in cboFiltered item dissapeared ! i dont want it, i want to keep this "line" i want only use filtration for currect "line" ?

 

[Van T. Dinh]

In the "previous line", the cboFiltered is NOT visible since it it behind
the cboUnfiltered. The cboUnfiltered is visible and the cboUnfiltered
should display correctly since all possible values are in the RowSource of
the cboUnfiltered.

Please re-read my previous reply and test carefully ...

--
HTH
Van T. Dinh
MVP (Access)

but in previuos "line" in cboFiltered item dissapeared ! i dont want it,

i want to keep this "line" i want only use filtration for currect "line" ?