Multiple List Boxes for Report Criteria HELP!!

[carmo]

OK! I have a form that allows the user to select their criteria from a list box for a certain report. I have a function that loops through the values selected. These values are then in the WHERE clause of the openReport method. Now I want to add more list boxes to selection criteria BUT HOW CAN I USE MULTIPLE WHERE CLAUSES in the openReport method? Thanks!!

 

[ad2]

Wouldn't you need the criteria the user chose on the form in the query that is the basis for the report?

criteria row in the query
[Forms]![frmReports].[cmboProduct]

 

[Trendsetter]

In the SQL statement that you are generating you can have numerous WHERE statements which can be connected by AND or OR.
The way you describe what you want - they will be ANDs like:

WHERE ProductID = [Forms]![frmReports].[cmboProduct] AND
WHERE ColorID = [Forms]![frmReports].[cmboColor]

 

[carmo]

Let me re-phrase....
I want to create a form that has 4 list boxes (with multiple selection available on each list box). These list boxes serve as the criteria for a query that feeds a certain report. I want the user to be able to do multiple selections on each list box, then click on the "submit" button to generate a report. What is the best approach to develop this?? Thanks everyone.