Textbox transfer

[poporacer]

I saw somewhere some code for two listboxes that you can move the information from one to the other, like the query wizard. Anyone know where I can find it?

Thanks

 

[ajetrumpet]

you basically do it like this (from the first combo to the second).

works the same for listboxes (to switch the values back from the one box to other, just repeat the process that is shown in the form's code).

A similiar concept can be seen here as well: http://www.access-programmers.co.uk/forums/showpost.php?p=645051&postcount=8