Changing order of records by dragging

[Guest]

This is similar to another thread but slightly different, I think. I too
want to change the order of detail records in a subform but don't want my
users to have to increment, renumber, resort etc. I don't mind handling the
sort key behind the scenes, but is it possible to have a user select a record
and then drag it to another position (like the tab order screen)?

Elaine

 

[Guest]

I thought I should respond here, doesn't seem like anyone else was going to!
Doug Steele demonstrates how to code drag and drop into your application in
two articles for Pinnacle Publication's Smart Access in January and February
of 2004.

You can download the columns (and sample databases) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

I'm still working on this for a continuous subform which seems a little
tricky.