Combo Box vs List Box

[Marckas]

I have a form with some VBA coding behind a command button. This form has a combo box drop down where I select the resource name and hit the command button and it will retrieve the report for that resource. So it is one report at a time. Now, I want to combine all the reports that I multiple select if I change the combo box into a list box. It does not work, it shows a blank page for the report even though I multiple select or even just select one, it does not give me a report. I am just wondering why it would do it in a combo box when I pick one and not a list box....any suggestions!!!

 

[Remou]

You cannot simply use equals with a multi select list box, you need to iterate through the array and use, say, IN in your SQL. Have you done this?

Here are some notes on filtering a form:

http://support.microsoft.com/kb/135546

 

[Marckas]

That worked! Thanks a lot! Remou