Copying data between lists with value lists as recordsource

[CrArC]

Hi there,

I've been trying to copy the contents of a listbox containing a value list from one list to another. There seem to be techniques on the internet for moving data between lists using recordsets but I don't see how to apply that when using a value list instead of a table/query as a recordsource.

I can copy data between the lists, but only one item at a time, and only the item I last selected in the source list. I could use the code I already have to do the job, if I knew how to make the selected item in the source list change/move down the list with each iteration of the copy process. Is there a way to do that?
Cheers!

 

[Guus2005]

Exchange the value list and don't forget to set the RowSourceType to Value list and if necessary the column count and widths

 

[CrArC]

Thanks mate, I might give it a go but as it turns out I've dumped the data into a table generated temporarily with SQL when the form is loaded. It actually seems easier to link the different lists to the table and then requery them when neccessary plus I can't quite get my head around the use of those listboxes!
Heh, I'll probably be back in the next couple of hours with another problem, I'll find a way...