User-friendly way to customize sort order

bri
03-18-2003, 06:02 PM
I have a very large lookup table in Access.

I have added an "Order" column where the user can assign each record a number so that the table can be sorted in the order the user wants rather than the order the items were entered.

The lists are getting rather large and hand entering the "Order" value is now a major pain.

Does anyone know where I can get a drag and drop ordering form/control similar to the Access Tab Order wizard? One where I can just select a record (or group of records), drag it to the desired row in the table and drop it. Then the code automatically changes the order column values.

Has anyone built one of these before? Would you be willing to share?

bri

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum