Table List box used as query / report selection

[lisaharris]

I have a table with a list box for departments to be used in a query, which in turn is bound to a complex report. It works fine with a single selection but I need the users to be able to select more than one department. How can I make this happen?

__________
Veni, Vidi, Visa: I came, I saw, I charged it.

 

[dhookom]

Are you using a multi-value field in your table? Or, are you referring to an unbound multi-select list box on a form that you want to use to allow a user to select multiple departments to include in the report?

Duane
Hook'D on Access
MS Access MVP

 

[lisaharris]

Right now, the Departments table is just a simple table with the 11 departments. I created a table called ReportDepartment, which uses the Departments table as a row source -- tried using List box and Combo Box. I need the user to be able to select either one or multiple departments to generate the report.

__________
Veni, Vidi, Visa: I came, I saw, I charged it.

 

[dhookom]

I would use an unbound listbox on a form. There are several FAQs that might help at query FAQs.

Duane
Hook'D on Access
MS Access MVP