Multi-selection from list box to reports

[SgtSaunders69]

I'm trying to adapt the code shown on the allen browne website (code in attachment) to my database to enable me to send multiple selections from a list box to whichever report I chose to run. The report to be used is selected from a combo box. The selection in this combo box goes to the code embedded in the click event on the button on the form. My problem seems to be that this code is designed to have the reportname embedded in the strDoc = "Products by Category" line. I'd like to be able to have this line pointed at the combo box, but that doesn't seem to be possible (give my coding limitations). Can someone advise on how to accomplish this?

Thanks...

 

[pbaldy]

Your attachment is your post repeated, unless I'm goofed up. It sounds like you want:

DoCmd.OpenReport Me.ComboName,...

which will work as long as the bound column of the combo contains the actual name of a report.

 

[SgtSaunders69]

Geeze... pretty dopey... corrected and put the right attachment...>

 

[pbaldy]

So did I answer your question? Or you could do this:

strDoc = Me.ComboName

 

[SgtSaunders69]

Worked great... thanks.