I've used this kind of logic before and here's what I've done to make it work.
1. Have the list box populate a table. You may want to delete the data in that table first if you are going to run this report over and over again.
2. Once the values are in that table, edit your query so that the criteria is selecting from that table. eg:
Criteria:
In (select [column1] from [tableA])
3. Then the report will have the control source as this query.
A cmd button can be used to do steps 2 and 3 in succession.
Hope this helps!
Rgds,
Chris
cbuono@jikkou.com