Identify Rec in Continuous Form

[Richard S.]

I have a subform with Continuous Form display with a query as the Record
Source. I want to enable the user to resequence the records by identifying
the rec to be moved with a mouse_down event using the right button, and then
to release the button over the rec in the desired new position. I can store
the rec identification for the mouse_down event, but haven’t been able to
identify the rec at the mouse_up location.

Each rec has a hidden sequence number field. If I can retrieve the sequence
number field of the rec at the new location, I can complete the resequencing.

I will appreciate help in how to read the data from the rec at the mouse_up
position, or to accomplish the repositioning through some other user-friendly
means.

 

[Arvin Meyer MVP]

There is no drag and drop capability in Access forms which can resequence
records. I have resequenced rows for quotations by adding a line number
field, then sorting the form on that line number. If necessary to resequence
records, I've renumbered manually. I've also written code to do it for
simple data (slide names) with Up_Down buttons and code which I remember
correctly, wasn't trivial. You do not want to encourage sequencing database
records when you can usually sort on criteria in a report.