Copying values from listbox to a listbox - easy question

[DRathbone]

I have a blank listbox on a form with a 'add' button beside it, once 'add' is clicked a second listbox appears (had visable = false) on click visable = true. The second list has many values listed within it (based on a query), a second button also appears with the list box '<' - with the intention to move values from one list box to the other.

I believe theres a 'MoveLeft' command that will move the values from one listbox to the other?

Will moving the values update the query? ie. its its moved once the value will not be visable in the second listbox again? As I dont want this to be the case I want to to copy the value to the first listbox rather than remove it from the query