How to copy list-box results using ctrl-c or command button

[XFiles_nerd]

I have created an access form that outputs the results of a series of drop down selections into a list-box. I am looking for a way to copy the results in the list-box, so the user can paste the results in documentation forms they use for clients.



Is there a code I can enter, say for an 'On Mouse Down' Event, that would allow the user to use Ctrl-C to copy the entire selection or even just the results that appear in the ResultDetail list-box? I am also open to ideas using a command button, if the coding used is easier to understand.

I have attached a copy of the database to give an idea of what I mean.
Other details: Access 2007
Windows XP

Thank you in advance for any input. Peace.

[June7]

Review this for code on working with listbox http://allenbrowne.com/ser-50.html

I think you will have to use a command button click event.

[XFiles_nerd]

Thanks for the response June7. I spent the evening reviewing the code on the link you provided and had a hard time incorporating a code that would do what I wanted. Which is fine, it just means I had to find an alternative solution. I decided to use a command button that would generate a report with the results in which I could do a Ctrl A, Ctrl C then be able to paste the table into the documentation.
Someone also suggested using a subform for the results rather than a listbox, but it wasn't as 'pretty'. If anything I hope this helps others who may be looking for a solution relating to this.