Report via List Box

  • Thread starter Thread starter lcannon1
  • Start date Start date
L

lcannon1

I need to know if there is a way to have a user print a report based o
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 jus
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 i
the list box and these are not in a query.

[forms]![frmtranssearch]![lstbxresult
 
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]
 
Back
Top