Multi-select listbox to create report

[digs]

mulitiple choice

I have a form that has a combo box that pulls down a list of teams. Once a user picks a team and clicks print button it opens a query just for that team ([team]=[Forms]![Faculty sickness]![team]). What I want to know is there any way you could have a multiple choice of teams so the query will run for more than one team.

 

[Mile-O]

Do a search on multi-select listboxes and QueryDefs.

 

[digs]

I have got a form that contains a list box called area. what I'm trying to do unsuccessfully is get the list box to select an area or multiple areas and then use these to open a report.

 

[daveUK]

You will need to create a dynamic query and report. As SJ McAbney said, search the forums as there are lots of examples of this. Also take a look at http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

HTH

 

[pono1]

Here is yet another example to throw into the mix... The attached files demonstrate how to filter a report based on the selections made in a listbox. The code behind the Run Report button moves through the listbox, collecting selected items and adding them to a string which is used as the criteria for the report. The code is fully commented. (The 97 file is untested.)

Regards,
Tim