Query from multiselect in a listbox

[Nikky_Pickles]

I have set the multiselect property in the list box to simple and I want to
be able to run a query based on the selections made. I'm not sure I
understand all the code to use - as I have copy-pasted the example in the
help file (changing the references as appropriate of course!) and it doesn't
work. Can anybody provide an idiot-proof answer?

 

[Allen Browne]

A query cannot read the values from a multi-select list box, but you can do
it programmatically.

There is an example of how to create the WhereCondition string for the
OpenReport action in this article:
Use a multi-select list box to filter a report
at:
http://members.iinet.net.au/~allenbrowne/ser-50.html

 

[Nikky_Pickles]

I think this just about covers it. thanks

A query cannot read the values from a multi-select list box, but you can do
it programmatically.

There is an example of how to create the WhereCondition string for the
OpenReport action in this article:
Use a multi-select list box to filter a report
at:
http://members.iinet.net.au/~allenbrowne/ser-50.html

 

[Nikky_Pickles]

Actually, is it possible to show the results in a query, rather than a
report? We need to export the results to an excel spreadsheet.

 

[Allen Browne]

I guess you could generate the SQL statement in your code, and then assign
it to the SQL property of the QueryDef

strSQL = "SELECT ...
CurrentDb.QueryDefs("MyQuery").SQL = strSQL

 

[Nikky_Pickles]

Thanks - I'll give it a try

I guess you could generate the SQL statement in your code, and then assign
it to the SQL property of the QueryDef

strSQL = "SELECT ...
CurrentDb.QueryDefs("MyQuery").SQL = strSQL