using listbox to reorder records

[SunWuKung]

I would like to make it possible for the user to arbitrarily reorder records.
Maybe displaying records in a listbox and have a Move Up - Move Down button. I am sure that this is a common problem and I would be grateful if somebody could direct me to a solution because I couldn't find it.
Many thanks.
SWK

 

[Peter D]

Well, you'll need another field to keep track of your record order, and as a record is re-ordered, that field has to change to a value that is between the record above and below it. It's tricky.

We've developed a tool that handles this problem and allows listbox re-sorting via drag and drop. It's called Drag-N-Dropper and a shareware version is available here: http://www.peterssoftware.com/dd.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

 

[SunWuKung]

Hi Peter,
I can imagine this being tricky with drag and drop but with a move up button you simply switch the order value with the one above the selected. I was hoping somebody have already written that code.
Thanks anyway.
SWK