Pass query to ListBox to select record

[allend5]

I am trying to find out if there is a way to pass the results of a query back to a userform listbox that the user can then scroll through select the client and load this into a sheet. so far this is the code that I have:

Please Login or Register  to view this content.

At the moment this passes the result directly to the active sheet. This could be multiple records which is not what I want, I only want a specific record as selected from the listbox. I have also attached an image of my userform.

Any help greatly appreciated.