Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 18th, 2008, 02:05 PM
Registered User
Join Date: Mar 2008
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
Default 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.

Old April 18th, 2008, 03:14 PM
Registered User
Join Date: Mar 2008
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post

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.

Similar Threads
Thread Thread Starter Forum Replies Last Post
open a report from a list box Bob Peterson Access VBA 2 January 16th, 2007 06:17 PM
List Box in Report mateenmohd Access 3 April 23rd, 2005 07:00 AM
List Box in a Report abhiinbwir BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 4 July 19th, 2004 12:57 AM
refer to list box on another form timbal25 Access 2 August 5th, 2003 07:05 AM
Copy list box data vladimir Access 5 July 23rd, 2003 06:23 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.