I have a form with 2 list boxes
The first list box has a query as its record source and so displays the values retrieved from that query.
There is a command button whose purpose it is to take a selected record from that first list box and write that value into the second list box as a record source. There is another button should allow you to copy every value in the first list box into seperate entries in the second list box. Technically you should be able to select one or two or even all of those values into the second list box.
This information is temporary. At the close of the form the record source for the second list box is reset to nothing.
How would you do that in code
The first list box has a query as its record source and so displays the values retrieved from that query.
There is a command button whose purpose it is to take a selected record from that first list box and write that value into the second list box as a record source. There is another button should allow you to copy every value in the first list box into seperate entries in the second list box. Technically you should be able to select one or two or even all of those values into the second list box.
This information is temporary. At the close of the form the record source for the second list box is reset to nothing.
How would you do that in code