multi-column list box values moved to 2nd list box
I have 2 list boxes:
The first, lstOne, contains 2 columns, is single-select, and gets populated from a query.
The second, lstTwo, contains the same 2 columns, and gets populated when the user selects a row from lstOne, and clicks on a command button that is supposed to copy the selected row (both columns) from lstOne. However, I seem unable to copy both columns from lstOne to lstTwo into the corresponding separate columns. What's the trick?