Move item from one ListBox to another

[bulrush]

A2003 on Win XP.

I have a form with 2 list boxes, both with the same columns in the same order. When the user double clicks on the first list box, I want to copy all columns of that row to the second list box. This should be a one line deal in A2003 but I can't seem to figure it out using Access Help.

Any ideas?

 

[MStef]

Look at "Demo2ListboxA2000.mdb" (attachment, zip).

 

[bulrush]

Thank you. I have not had time to look at it yet but I will soon.

 

[ajetrumpet]

rush,

i did something like this too, here: http://www.access-programmers.co.uk/forums/showthread.php?t=164620

 

[DCrake]

And here is another one that works with bound and unbound controls

http://www.access-programmers.co.uk/forums/showthread.php?t=165549

David

 

[bulrush]

My initial thought was to use a listbox control. All I want to do is show all (or filtered) records from a single table, on a form. Is another control a better choice?

The listbox does not let the user change the width of the columns.

Also, the user may want to sort on a column or two in the control.