Append through list box

[vbaInet]

I've just quickly bashed this out so it hasn't been properly tested. Play around with the form and you will see the new implementations. In order for you to select more than one name in the box, hold down the CTRL key and select as many as you want (whilst holding down the key).

Create a backup copyof yours before using mine just in case you find mine too complicated to understand. Or just simply rename mine and test it until you get yourself fully acquainted.

The bits you should work on now is removing the selected item(s) from the list box and the undo bit.

See attached.

 

[syntaktik]

Wow! Youre amazing at this! It works. I bet i could figure out how to make it do the reverse. But my last problem is to prevent duplicates. Just make an index?
Actually. haha, I think i am overstaying my welcome with all these questions, but, how come does it not add thme to the other table? Only to the other list.

 

[vbaInet]

Wow! Youre amazing at this! It works. I bet i could figure out how to make it do the reverse. But my last problem is to prevent duplicates. Just make an index?

If you remove the item from the listbox on the LHS straight after it was added to the RHS it will (in essence) prevent duplicates (because that record will no longer be there). Think about it!

Most importantly, the record that is added to Listbox2 isn't updating your table. So that's another thing to figure out. All I did was unbind listbox2 for it to work. Create an "Assign" button underneath Listbox2 which will then add all the records to the table. It's a more efficient way of doing it.