Listbox question - copy values from one lstbox to another

[DRathbone]

Wondered anyone could help....... see attached file

I'm trying to get the values from the right hand list box show (two fields selected ('location' and 'description')) and once you click "add selected" the list box on the left is populated with a COPY of the 'location' name selected (so the value is still in the right hand list box)

I have had a look at this sample http://www.access-programmers.co.uk/forums/showthread.php?t=123021&highlight=.additem but its unsufficent as it uses a table to flag selected items etc. and removes the item from one selection box to another - where as I want to simply copy the 'location' value and leave the list on the right still populated with that value

Many thanks in advance

 

[DRathbone]

Answered my own question - the control was bound to the incorrect column

 

[RuralGuy]

Excellent! Thanks for posting back with your success.