copy complete list box to a second list box

[mdavid]

Hi, I have a list box on a form and I'd like to copy all the content (not just selected rows) to a 2nd list box.


Any help appreciated

David

[ssanfu]

You cannot "copy" the contents. Controls do not "STORE" data.... tables store data.

Set the 2nd list box row source to the same source as the first list box.

[mdavid]

Thanks Steve for pointing me in the right direction. This worked for me:

listboxName.RowSource = "queryName"

[ssanfu]

Excellent!!