copy a list box from a form to a report
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.