Hi,
If the users are not selecting the records in the listbox then you are
basically just trying to print the RowSource of the listbox control.
DoCmd.OpenReport "Report Name", acDesignView
Reports![Report Name].RecordSource =
Me.ListBoxControl.RowSource
DoCmd.OpenReport "Report Name", acViewNormal
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| From: lcannon1 <
[email protected]>
| Subject: Report via List Box
| Date: Tue, 6 Apr 2004 14:11:21 -0500
| Message-ID: <
[email protected]>
| Organization: MSAccessForum.com
| User-Agent: MSAccessForum.com
| X-Newsreader: MSAccessForum.com
| X-Originating-IP: 66.28.225.194
| Newsgroups: microsoft.public.access.macros
| NNTP-Posting-Host: 69-56-172-122.theplanet.com 69.56.172.122
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.macros:31085
| X-Tomcat-NG: microsoft.public.access.macros
|
|
I need to know if there is a way to have a user print a report based on
records
| in a list box without selecting or clicking on a record???
|
| This will return an record selected, but I am not sure on how to just
say print all records currently showing in "lstbxresult".
|
| All the records returned in the listbox by a query but there is
| code that lets the user select certain criteria to limit the records in
the list box and these are not in a query.
|
| [forms]![frmtranssearch]![lstbxresult]
