That doesn't really offer anything new beyond what's already been described. Doesn't matter that the code writes into listbox columns instead of rows, code techniques involved are basically the same.

The first listbox RowSource is a query and listbox is set for multi-select. Since it is a query, removing items involves filter parameter in query and requerying. So that brings us back to setting a Yes/No field in table and basing the listbox RowSource on a query that filters on that field.



Programmatically adding items to a listbox value list is easy, removing is trickier.

Bing: Access VBA synchronize user selections listboxes

Possibly, both listboxes can be based on a filtered query, depends on your db structure.

http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx