moving records from one list box to another

[grjoni]

Hi

I have in my form 2 list boxes. One displays the contents of a table and I want to be able to select records from it an move it to the other listbox for printing or exporting to excel. How can I do this?

 

[KenHigg]

I think there is an example of this in the Access FAQs forum titled' Cascading Comboboxes '.

 

[grjoni]

That is not the same, what I want to select few records witch have nothing in comon and display them in the other list box.
Isn't the best way to do that to make new table and copy records from the original tabel to the new table? and how do I do that?