Hi there,

I have made a parameter query that is linked to a report, prompting the user with [What codes are you looking for?]. The Code field contains a variety of codes. However, when the parameter value shows up it only allows the user to choose one code and therefore only one code shows up in the report. I want the user to be able to choose more than one code. For instance if I wanted to see the report of 3 or even 4 codes. How can I make this possible?

I almost never use parameter prompt queries because they are so limiting.

This article (http://www.mvps.org/access/forms/frm0007.htm) expalins how to use a multi-select listbox to supply parameters.

I almost never use parameter prompt queries because they are so limiting.

This article (http://www.mvps.org/access/forms/frm0007.htm) expalins how to use a multi-select listbox to supply parameters.

Yes I agree with you. However, I will see what I can do with this article. Thanks again.