Using dblClick to Move data between List Boxes

[KristopherKane]

Hello,

I am looking for a way to use the dblClick function to move the current row of a list box to another. The idea is that users can look through data and pick certain rows to be printed in a report. I am not sure how to go about doing this and am not sure if it is the best way. The second listbox is so the user can review their selections before printing a report.

Thanks,

Kristopher

 

[rborob]

cant you have an event that runs when the user double clicks ona list in the first box. it would then copy data across to whatever table the second listbox is representing and then requery it.

 

[ansentry]

If you click the link below, it will take you to Microsoft's Download section and you will see that the link takes you to;
Access 2000 Sample: Database of Sample Forms.

Download the sample db and you will find an example in there that allows you to drag from the left to right or right to left using 2 list boxes.

You will also find other helpful forms in the sample.


Click here

Good Luck and Welcome to the Forum!