I want to build a form that works in the same way as a table in design mode, that is, being able to drag and drop rows up or down the list.
The use is to create a list of jobs allocated to a person and be able to quickly resort them as needed as new jobs come in and priorities change.
An idea I have is to use a listbox, highlight a line and then use up/down arrows to move it, by reading the line and its index number, delete the line from the box and then reinsert it by adjusting the index number but I think it will only allow steps up or down of 1, which could become tedious.
Any ideas to improve upon this (including instructions) would be greatly appreciated.
My programming skills aren't that good and most of what I have done lately is only small mods to the database I built mainly with Access 97 (some years back).
Thanks to all in advance.