Change from Combo Box to a List Box in a Report...

[supplyside]

Presently, I have a form that allows individuals to select records from a combo box. However, I want to change this field to a list box for the ability to select mulitiple records. Presently, the form holds data to be applied to a report. When I have the combo box in place the report will work. When I change the combo box to a List box with Multi Select "Extended" choosen, the report does not work. Is there anything else I can do? To get the functionality working?

-- Scott

 

[danvlas]

That's because a combo box has only one value while a listbox can have more. Use the ItemsSelected collection of the list box to retrieve and pass all selected values to the Where clause of the report recordsource and it will work.

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[supplyside]

Thank you so much for helping me. This solutions has helped me a great deal. I just never looked at the information at this way.

-- Scott