[AccessD] Scheduling Application - Changing Sort Order of Individual Items

Hi:

I'm in the process of adapting a scheduling program for a manufacturer to Access (they currently do this in Excel).

Basically, the application will have a list of products on a form, and the user must be able to move the individual products up and down in the sort order via drag and drop or button click. Is this possible in Access?

ProductName         Scheduled Order
Widget 1                1st
Widget 3                2nd
Widget 5                3rd
Widget 8                4th

For example, I need to be able to quickly move Widget 8 to 2nd, and have Widget 3 and Widget 5 automatically slide down to 3rd and 4th respectively.

Thanks in advance.

Larry Mrazek
lmrazek at lcm-res.com
http://www.lcm-res.com/