click and drag

[Lee Taylor-Vaughan]

Hi group,

I was wondering, can access do click and drag features. i.e. 2
subforms/listsboxes on a form and click and drag one record between the two
subforms/listboxes.

TIA

Lee

 

[Allen Browne]

Access is not really set up to do this, but you can fudge it.

With a simple list box, clicking selects the record, so it becomes the Value
of the listbox.
The MouseUp event of the list box that was clicked gives an x,y reference so
you can figure out if the user was over the other list box when they
released the mouse.
The "move" consists of executing action query statements, and requerying the
list boxes.

This drag'n'drop functionality may not be obvious to the user. It may be a
better interface to place two command buttons between the list boxes, each
with an arrow. Clicking the arrow moves the selected item(s) to the other
box. You could also respond to the double click of the list box. The Access
wizards use this approach.