List box on Form (2003)

[benji]

I have form that I will use as a report menu that has 4 list boxes and I have a command button that executes a query. Problem, I want to have the ability to choose any combination of choices - 1,2,all, or none in each of the 4 list boxes. I have the query set in the criteria by Forms!FrmReportMenu!cmbstate for one of the list boxes and this works when 1 is selected in the list box. However if I pick 2 or more from a lsit box ,nothing comes back from the query. Should I change the criteria on the criteria or is there something else I can do?

[HansV]

See the thread starting at <post#=593,790>post 593,790</post#>.

[benji]

Thanks I will see what I can come up with.