Access 2007 VBA : Building a listbox with selection choices from another list box

Posted by Justin on Stack Overflow See other posts from Stack Overflow or by Justin
Published on 2010-05-27T13:21:51Z Indexed on 2010/05/27 13:41 UTC
Read the original article Hit count: 386

So there are 8 categories that may be associated to each order, but not necessarily all of them. So i was going to build a list box that allowed the user to double click each of the category they wish to associate when they have an "Order Detail" form opened up (unbound form that has hidden text boxes with all needed ID numbers).

I want to have another empty text box right beside it that will allow me to append the selections (up to 8) so the user can see that they have been added.

So one list box with the default choices, and when a choice is double clicked, it adds that choice to the second list box to see the tally so to speak.

What is the VB for getting something like this done?

Thanks Justin

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about vba