Reverse Cascading Combo Box's ??

[cmraguilar]

So i've got the whole cascading combo box process down to a T, but now I
would like to get a little more sophisticated with it. I have a form with 2
combo box's on it: cboParentName and cboChildName. The combos are set up
where they receive parameters from other forms or can be selected by using
the drop down menu. That process works.

The trick would be when cboChildName receives the parameter from the a
different form, it would "auto select" cboParentName with the correct name.
Thus limiting cboChildName to the proper list.

cboParentName already has the code:
cboParentName_On Change
cboChildName.requery

so I think the rest would only be to do the reverse cascading to the "first"
combo box(cboParentName)

If this is to confusing, let me know and i'll try to clear it up.

Thanks.

 

[Jeff Boyce]

Something doesn't seem to compute...

If you pick "Billy" for the child's name, wouldn't you have a host of Parent
Names that go with that?

If you want to use cascading combo boxes, you'll need to decide which one
starts it, and which one cascades...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[cmraguilar]

If your selecting the child's name from the combo box, then yes you are
correct the parent's name would be selected first.

My example would be if the parameter for the child's name was brought over
from another form. "Billy" would be passed into cboChildName and
cboParentName would be filled in with the proper name. Then if you were to
click on the cboChildName, you would only see the respective names that were
associated with parents name.

 

[excel/access-chump]

I tried to get a similar operation going on a form and subform I was
building. I was unable to find any solutions either. "NetworkTrade"
(Another user) made a great suggestion.
You could use a third combo box that lists ALL the childrens names. When a
selection is made it updates a simple text box that informs you of the
correct parent name. (Simply done, but effective.)

I don't know what volume of information you are dealing with and if as a
result of that volume this suggestion is useful or not, but maybe it will
spark an idea. <grin>

 

[Jeff Boyce]

How can the "cboParentName" be "filled in with the proper name", when you
haven't selected which parent yet?

I think I must still be missing something...

Regards

Jeff Boyce
Microsoft Office/Access MPV

 

[cmraguilar]

Thats what I'm trying to figure out. The value for cboChildName would be
sent in as a parameter from another form. The value for cboParentName select
after cboChildName received the parameter value. Thus, the "reverse" of the
cascade effect.

 

[cmraguilar]

Thats a pretty good idea. Although I think I might set the text box property
visible=false and then set cboParentName to select from the parameter or the
hidden text box.....

Or just send both parameters when the form opens....

Thanks for the ideas and changing my focus of getting the final result.

 

[excel/access-chump]

Glad I could help!
Just a note:
I tried to implement both those ideas (to avoid clutter) but ended up
resigned to the method I mentioned. If you find a way to make it work
without having that "extra" step it would be great if you would post it so we
all could benefit from your discovery.

 

[ti-loup]

no speak inglis?sory

"cmraguilar" <[email protected]> a écrit dans le message
de groupe de discussion :
(e-mail address removed)...