Combo box to List box to Combo box

[Pusher]

Hi all,
I have a List box that is filled by a query that is triggered with a combo box, how do I extract the info in that list box so I can fill another combo box. I used Me.List.Value but it does not work. The bound columns are all ok but I can’t get it to work. Also I don’t know should I use after update on the first combo box to be the trigger for extracting the data or the after update on the list box.
Btw The result of the query is Only one line of data.


Thanks for the help

 

[Beetle]

If you want the second combo box to display the same data as the list box, then why not just use the same query (that populates the list box) is it's row source as well?

No need to "extract" anything from the list box.

 

[Pusher]

The problem is that when I do that I need to manually select the one result that is in this second combo box. I want that when I enter the one combo box I automatically fill the second combo box with the result of a query that is just one line of data.

 

[vbaInet]

The point that Beetle is making is base the Row Source of the combo box to the same RowSource as your listbox, but this time set the criteria to reference the listbox. Requery the combo box in the After Update event of the listbox.