MultiSelect Listbox as Crosstab Query Parameter

[nstratton]

A little background as to what is going on. I have created a chart on an unbound form, the sole purpose of this form is to hold the chart and nothing else. With a combination of the chart wizard and VBA I have the chart formatted and populating like I would expect. Now I want to be able to limit/filter the chart based on user input from a form.

I came across this link in searching how to filter the chart and it does it seems perfect for what I need. http://www.pcreview.co.uk/threads/crosstab-values-of-my-chart.1653639/

Now the problem is I would like to implement a multiselect listbox to do this. My understanding is these types of listboxes need VBA to get the values. I have not attempted anything yet as I do not know where to begin with it.

If there is anything I can provide (code, database, etc) I will post.
FYI: This is a desktop version of Access 2010

 

[Ranman256]

dont use multi list box, (it takes programming)
do it without code using a table. The user dbl-clicks items in the list box to use.
an append query puts them in a 'picked' table.
this table is joined to your data table to pull only those items.

similar to the diagram here
http://www.accessforums.net/reports/generating-report-based-multi-select-listbox-54222.html

 

[nstratton]

I understand the concept of what you are saying but am struggling to understand the full implementation without code. Wouldn't you need an On_DblClick event or something similar to trigger the append query? Guess I'm not understanding how the append query will know which values to pick from the listbox without some sort of code somewhere.

Also, there may be situations where the listbox is not needed at all and the chart is being filtered another way. Will your method account for a situation like that?