Cascading Combo Boxes

[MarinaJ]

I have been reading about cascading combo boxes and I wonder if it is possible to have the final (results) combo box display if you have more than one combo box to select from. My first combo box would be to select a crop, my others would be to select weeds. Finally the third, (cascading- hopefully) would give my result according to the choices.

I previously had these combo boxes set up to execute on a command button (once selection was made) then saved to a query then open a form which has a subform linked to the query. Is this the only way or am I out to left base.

Thanks.

 

[Alexandre]

It is perfectly possible to cascade three comboboxes, if this is what you are asking. Do you nrrf hrlp to set this up?
As to your second question, other eventually interesting alternatives I can think of include:
- (for hierarchical data) using a treeview control
- Using sub datasheet (queries or forms in datasheet view)

 

[MarinaJ]

Thanks,

I'm just starting with access and I could use some guidance to set it up with three (actually I have more like 9 boxes).

I have the instructions to make the 2 combos work, but if you could explain the concept to have them all link up that would be great.

I will do some research in the treeview control, and your last suggestion was what I had, I think?

 

[Alexandre]

These are really three cascading combos aren't they: selection in Combo1 determines a subset recordsource for combo2, and selection in combo2 determines a subset recordsource for combo3?
Also, are they bound combos (do you need them to retain and display recorded values while shifting from one recor to another in your form?)

I don't think that whatyou have at the moment are subdatasheets (a2k and 2002). The idea in that case is to have three linked tables/queries and let the user expend embedded subdatasheets based on those tables/queries. See access help on 'subdatasheet'.

 

[MarinaJ]

Combo box #1 is not related to Combo box set #2.

My first box is selecting the crop.
My second will be selecting weeds and since it's probable that they will have more than one weed in their field, I would like to set up more than one combo box to give them multiple selection.

Then Combo 3 would give my results (herbicide choice).

If cascading combo boxes are not possible could I set up option controls and list all weeds?

I don't think I need to shift from record to record. Later on I will work on the results box and elaborate on herbicide information when then click on each herbicide.

I will most certainly look up the subdatasheet and treeview control this evening, thanks for your help Alexandre.

 

[Alexandre]

Then 1 combo, a listbox allowing multiple selection instead of combo2, and I m still not sure about combo3. It seems to be only meant to display results. It could be a query and not a combo, thus allowing to display other info related to resulting herbicides?
Confirm and i'll set up a sample db.
BTW, the funny thing is that my background is in Agronomy

Alex

 

[MarinaJ]

I'll make a few changes tonight, with combo 1 as is;
Combo 2 as a listbox;
and Combo 3 as a subform executed with a command button

I can also change my query so I can include some or all of the notes/restrictions which go with herbicide selection to appear on my subform. Maybe I won't have to worry so much about the additional information that way.

As long as my datasheet view does not get to big (and it probably will because you know how many restrictions and notes there can be prior to application).

I'll post again tomorrow, once I do some changes and research.

Thanks again.

 

[Hayley Baxter]

Samples of Cascading Combos

I can provide you with a few samples of how this is done if you are intersted send me an email.

Hay