ListBox To ListBox Drag Drop And Dataset?
Posted on 2009-05-19
I've found many good articles concerning ListBox drag-n-drop, but I'm still unsure how to update each ListBox's datasource. In this case each Listbox needs to connect to it's own dataset. Each datset will contain 4 columns, one of which is displayed in the ListBox. Upon drag-n-drop, the entire row needs transfered to the opposite dataset. I need to move data back-n-forth as well, not just one-way.
ListBox1 (displays only FirstLastName)
ds1.tb1 [ID, FirstLastName, Mid, Bday, SS] (entire row moved to other dataset)
ListBox2 (displays only FirstLastName)
ds2.tb2 [ID, FirstLastName, Mid, Bday, SS]