Expand this code to be more usefull (1 Viewer)

[syntaktik]

I have two listboxes inorder to append a list of names. Then i discovered this pice of working code on this site.
However, there are a few problems with it.
One, It will create duplicates. (fixable with an index, but I want to set them to hide after selecting them)
Two, if I open the form again to ad more, it deletes the ones I didn't select again.
Three, it wont list the people from the other table.

I think this is a bit of a big project , but any answer would help me greatly.

 

[DCrake]

Take a look at this link. It should have all you need.

David

 

[syntaktik]

Actually, this is just what I want to do, but how do i make it append rather than flag it?