Moving data between list box

[Maracay]

Hi Guys,

I am trying to use 2 list box to move the highlighted data between them, I
have a list of data coming from a Table in first list box, and 2 buttons, 1
button to move the data from the list box 1 to the list box 2 and the second
to move the data from the list box 2 to the list box 1.

So far what I have is this code in the button that move the data from left
to right, but move the whole set of data not just the highlighted one, and
also I need to delete the data that was just moved.

Me.List3.RowSource = Me.List3.RowSource + ";" + Me.List6.RowSource

Any help with this will be appreciated

Thanks

 

[John W. Vinson]

Hi Guys,

I am trying to use 2 list box to move the highlighted data between them, I
have a list of data coming from a Table in first list box, and 2 buttons, 1
button to move the data from the list box 1 to the list box 2 and the second
to move the data from the list box 2 to the list box 1.

So far what I have is this code in the button that move the data from left
to right, but move the whole set of data not just the highlighted one, and
also I need to delete the data that was just moved.

Me.List3.RowSource = Me.List3.RowSource + ";" + Me.List6.RowSource

Any help with this will be appreciated

Thanks

This can be really tedious to do using Value Lists - not only is it hard to
remove a record, but it's hard to insert a new value into the proper
alphabetical order. Much simpler would be to base both listboxes on Queries;
they can be queries *of the same table*, just by adding an additional field to
indicate which box is needed. You'ld just update this field from 1 to 2 (say)
and then requery both textboxes to "move" the value.