Multi-Select Listbox for Report

[Guest]

I have a listbox that the users will select what items are included in the
report.
I know there is a way to have all the selected items show up in a single
textbox, but how do you get each selected item to show up in seperate
texboxes?

Thanks.

 

[Allen Browne]

Use a subreport instead of a listbox.

 

[Guest]

Thanks for the reply Allen.

It is a subform right now(using comboboxes), but the "higher ups" want to
use a listbox to do this.
Is it even possible?

Thanks

 

[Allen Browne]

Joel, anything is possible, but I certainly would not jump through the hoops
to create a list box that is tall enough to show all records and has its
RowSource set for all the matching records in another table, and uses the
Format event of the report to set the selected items of the list box, when a
subreport is just a few clicks to create, runs faster, and requires no code.

If you go to the trouble of programming it, the turkeys will then complain
that they can't drop the list down and change the selections on the report.

 

[Guest]

Alright Allen, Ill tell them that its not possible to do.

Thanks again for your advice.