Listbox drag & drop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to allow users to re-sequence items in a listbox by using
drag and drop, if so where could I find examples for Access 2003/VBA? I have
a sequence number field that I use to sort the listbox and I would like to
enable the ability to change the sequence of an item by draging it to a
different row location and re-assign the sequence number.

Thanks in advance for any help!

Jerry
 
I don't know of any way to do this with the listbox that comes with Access.
You may be able to find a third party listbox that will do this. The closest
thing I can think of using the Access listbox would be to place two buttons
(up and down) next to the listbox to move the selected item up or down the
list. You could set the AutoRepeat property of the buttons to Yes to allow
the button to be held down and continue to move the item in the list. If you
do, you'll probably need to Requery the listbox after each increment and
include a DoEvents in the code after the Requery to allow the listbox to
refresh so that you can see what is happening.
 
Thanks Wayne - I will give your suggestion a try, it should accomplish what I
am trying to do.
 
Back
Top