I have searched everywhere and cannot find an exact answer to my question. I have an Access 2000 Project and on my reports form there is a list box that is set to simple for multiselect. I also have a report based on a client table. Now, the list box is getting it's information from another table which is my marketing code table. Every client has a marketing code designated. I would like to open my report while filtering the client data based on what marketing codes are selected by the user in the list box. I have the selections being stored in a collection right now, however, my where condition in my openreport command will only accept 1 item in the collection, when I do an or statement it errors out with "type mismatch". Does anyone have any suggestions? Whatever help you can provide would be greatly appreciated. Thanks Kerry