Use Multi-Select List Box as Query Parameter

[djf]

Is there a way to get the multiple selections from a list box into my query
as the parameters?

 

[Douglas J. Steele]

You need to use VBA. http://www.mvps.org/access/forms/frm0007.htm at "The
Access Web" is an example, although personally I prefer using code more
similar to http://www.mvps.org/access/reports/rpt0005.htm since it generates
shorter criteria. (The first one generates a criteria like Field1 = Value1
Or Field1 = Value3 or Field1 = Value4, while the second one generates a
criteria like Field1 In (Value1, Value2, Value3))

 

[djf]

I found this code on an Internet search. I'm using method 2. I also found the
code that you've listed on the same search. Method 2 is working, with a few
things I'm trying to work out. My query has two criteria fields, one
generated from a combo box and one generated from a list box. I'm not sure if
I can use method 2 for this type of query. The code does work, however when I
modify for my db.

What is the difference between method 2 and the code that you suggest?

http://support.microsoft.com/kb/q135546

 

[Douglas J. Steele]

At a quick glance, I don't see any real difference between the two.

 

[djf]

Thanks for your help, I appreciate it.

At a quick glance, I don't see any real difference between the two.

 

[Demos Kasastogiannis]

Is it possible to apply these techniques to a crosstab query having a multiselect listbox together with some other criteria? My question is mainly refering to the "complexity" of the sql statement (which includes parameters, transform, group by etc) since the 2nd method is constructing the sql statement