Multiselect Listbox for Creating Pivotcharts

J

johnhildreth

Running Acess 03 in Win XP sp2. I have a form containing a listbox
with multiselect option. The idea is to allow the user to select from
the list all the items for which they want to print data in chart
format. I have a report and want create subreports within (number of
subreports equal to number of items selected in listbox). Each
subreport is a pivotchart for one item selected.

The problem is that the pivotcharts created contain no data when
multiselect is on. I can turn off multiselect and create one
subreport/chart with data. I can loop through the selected items,
trap the data from each selection that I need, create the subreports,
and print.....but how can I create charts AND use multiselect?

Thanks,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top