Forms

[martinw]

I have created a form called selectiondialogfrm with a list box called lstComplanies that is a multi-select. As I click on the names in the list box, they are displayed in a textbox called txtSelect. What I want to do is to Print a seperate report for each name selected. Any help would be greatly appreciated.

 

[llkhoutx]

Identify each selected row with

dim var as variant
with me!lstcompanies
For each var in .itemsselected
".column(0,var)" gives you the first field (hidden or visible) selected
".column(1,var)" gives you the 2nd field (hidden or visible) selected
etc.

'build the record source and/or criteria for your report here

'OPEN YOUR REPORT HERE

next
end with