I have created a report which only shows ONE record. The user activates the report by clicking the "Print" button on a form. The report does not have a record source as I do not want it to have any other record source other than the form it is being activated from. So all the fields on the report are set to =Form!frmName!frmControl.

Now, there are two list boxes on the form which I have populated using VBA. When I attempt to have these list box values copy to the report (using the above method =Form!frmName!lstBox they do not show up on the report. All the other fields on the report are working fine.

I've tried to do this in a number of different views, normal, layout, and preview. I hope someone can help me.

Thank you in advance.

Just to clarify things a bit... I DO NOT want the listbox to have any functionality on the report other than to display and print the values that are in the form. Thanks again.