Move Selected Items to and from listboxes

[wickidwe]

I have 2 Listboxes
the first list is based on a query
I need to select items from this box or part of each item and move to another listbox. the items in the second listbox will be used in a report.
I have previously posted on another forum with no real luck
fyi. the query is put straight in the RowSource.

:banghead:

 

[jdraw]

What exactly is the question?

 

[Mihail]

You can't move the items because the list box is bounded.
You can copy items (using VBA) or you can allow multi-select in the original list and is no need even to copy.

or part of each item and

What this mean ?

 

[wickidwe]

thanks, I dont mind which I use as long as the outcome is what I Need.
I need to move from the left to right and right to left . For that reason I dont think you can copy it from one to the other as I cant have the same info in both boxes.
does this make more sense?