How To Pass A Value In Visual Basic

[ABCDEFGHIJKL]

This is kinda tricky... and there may be another way to go about it. Basically I have a list box (contacts) which is populated by an SQL command, from my data environment. What I want is to pass only a single value at a time from the (contacts) list box to the attendies list box. So basically I can select from the list box contacts as people walk into a meeting and add them to the Attendies list box, one at a time. How the hell do I do this????

[Static]

if this is in VB (Not access)

in the Double Click event...

ListBox2.add ListBox1.list(Listbox1.listindex)
(If memory serves correctly )



if its in access...there is no add command...
you need to insert the name into a table...and have the other listbox point to that table

[ABCDEFGHIJKL]

Thats whats tricky, it is a VB form linked to an access database. What I want is to be able to move names from one list box over to another, and than take what has been put into the new list box and save it to the access data base.... any idea on how to do that????