Moving records between two listboxes

[MrBitsy]

I am designing an application for billing clients. I have two listboxes to
show the items to be billed and the items to hold over. A button allows
moving a billed item to the 'hold over' listbox and another button allows
the moving of an item from the 'hold over' listbox to the 'billed' listbox.

When the user is happy with their selections they can complete the billing
process. Both of the listboxes will be multi select so I want to know the
best way to deal with all this moving of data between the listboxes.

Is the only way to do it to walk through the itemselected property and
actually save the selected records back to the database and then do a
requery on the listboxes so the data 'moves' between the listboxes? Is there
a way to do this and only save the data once all the moves have taken place?

Thanks

 

[Wayne Morgan]

To make all the moves then save the data would mean that you would have to be "buffering"
the moves somewhere, perhaps in a temporary table. This would still require requerying the
listboxes so that the user could see what they have done so far. It is probably much
simpler to just make the moves as they occur.