Solved Print only Selected Item in a List box (2 Viewers)

[MarionD]

Good morning World,
I know this is probably a beginner question and I'm just having a bad hair day, but I am battling!
I have a form with an unbound list box for multiple selections. (2 columns - ID and DanceName) It gets it's data from a table called "tbl_Dance". I have a report that prints only one field from this Table. What I need is for the dance coach to be able to click the dance names in the listbox (selected Items) that she wants to practice on a given date, and print the report with only this one field (called stepsheet). How on earth do I do that? Thanks for any help!

 

[arnelgp]

here is a demo, view the code on the Button on form1.

 

[MarionD]

here is a demo, view the code on the Button on form1.

Wow! Thank you sooo much - thats amazing. You did all the work for me!! Thank you again - you saved my day! Hope you have an amazing one!

 

[DHookom]

There is a method using a single generic function for almost any multi select listbox here. It would not be the most efficient with larger numbers of records.