Populating a listbox with another listbox

[MykeRuiz]

Hello!



May I ask how do I populate listbox B with listbox A? If the user selected an item in listbox A (double click) the item will be added to listbox B.

Thank you!

[ranman256]

on dbl-click event, run a query using the listboxA in the criteria
qaAdd1FromList = i nsert into table ( field ) values ( foms!myForm!lstBoxA)
then refresh

sub lstboxA_dblclick()
docmd.setwarnings false 
docmd.openquery "qaAdd1FromList"
me.listBoxB.requery
docmd.setwarnings true
end sub

[orange]

Here is an older free video tutorial from Datapig that shows how to move items between listboxes.
Good luck.