|
Subject:
|
copy a list box from a form to a report
|
|
Posted By:
|
bjcountry
|
Post Date:
|
4/18/2008 2:05:14 PM
|
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.
|
|
Reply By:
|
bjcountry
|
Reply Date:
|
4/18/2008 3:14:44 PM
|
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.
|
