VBA Query Parameters to appear on report (1 Viewer)

Hello all,

I have a form with multiple "criteria" on them. Two are date related, the remaining four are list boxes in which the user can select one, multiple or all the items in the list. The user needs to select criteria from each of the 6 parameter fields and when they click on the command buttons on the bottom of the form, the query runs and a report is generated using these parameters.

I want to have the parameters appear in the report as well.

I have no issue getting the dates to appear on the report. My issue is getting the items in the list box to appear. The VBA code uses the In(function) and when I look at the query after the code is run, it shows the actual text values from each list.

How can I get those text values to appear in the report. I've tried a similar approach that I used for putting the date range on the report, but it fails.

Does anyone have any ideas about how to do that? I've searched everywhere and can find nothing on this.

Any help would be GREATLY appreciated.

Thanks.

JSalle0826