Cascading Combos - loose ends

[RexesOperator]

I have my combo boxes and text boxes all tied in and working (thanks to Bob and Paul).

Right now, in order to see the results of the first combo box selection in the second box, I have to manually click on the second box.

Is there a way to have the list show up automatically (I'm sure there must be)? ie without clicking on the second field?

 

[donbettis]

If I understand your question…

In the After Update Event of the first Combo put the following...…

Me.Combo2Name.SetFocus
Me.Combo2Name.Dropdown

Hope this helps

 

[RexesOperator]

Last question (at least for now) - how do I do it with a listbox?

 

[donbettis]

How do you do what with a list box?

 

[donbettis]

If you are speaking about having the second listbox show updated info after a selection is made in the first...

In the After Update Event of the first list box - add this...


Me.secondlistboxname = Null
Me.secondlistboxname.Requery

 

[RexesOperator]

BTW - thanks for replying - your method worked like a charm

In the After Update Event of the first Combo put the following...…

Me.Combo2Name.SetFocus
Me.Combo2Name.Dropdown

This eliminates the need to click on the second box to see the results after a selection is made from the first combo, if the second box is a combo box. How do I do this with a second box that is a list box?

Obviously there is a different method other than "dropdown" for the list box?

 

[donbettis]

If the row source of the listbox is something like this...

SELECT Table1.ID, Table1.[1], Table1.[2] FROM Table1 WHERE (((Table1.[1]) Like [Forms]![Form1]![Comboboxname].[Text]));

Add this to the After Update of the Combo...

Me.ListName = Null
Me.ListName.Requery

Setting up a combo to listbox cascade is the same as cascading combos...as far as row sources go...

Hope this helps...

Don

 

[RexesOperator]

Sorry - I guess I wasn't clear on my question. But I have figured out my own answer. Thanks for your help.

 

[donbettis]

Glad I could help and good to hear you got it figured out...