Solved How to Print ListBox Selected Multiple Data Record

smtazulislam

Member
Local time
Today, 04:49
Joined
Mar 27, 2020
Messages
808
I have a search List box where have a Search button.
After the results display some data. I want to print out from listbox choice multiple records.
How can I do that ?
 
dim var as variant
for each var in Me.lstBox.ItemsSelected
docmd.OpenReport REportName,View:=acViewPreview,WhereCondition:="ID = " & Me.lstBox.Column(0, var)
next
 
dim var as variant
for each var in Me.lstBox.ItemsSelected
docmd.OpenReport REportName,View:=acViewPreview,WhereCondition:="ID = " & Me.lstBox.Column(0, var)
next
Thank you so much.
Its work, Only one record.
But I would like multiple records.
 
acViewPreview, i think is modal? so it doesn't advance to next record.
 
You talking about Report Modal = Yes/No ;
My setting is Modal = No.
But I tried Modal = Yes
Its not work.
 
using Allen Brownes multi-instance.
the report is in report view.
select some items on the listbox.

see module2.
 

Attachments

Multiple selected record, Its opened Multi reports.
Not only one report.
 
ooh, i see.
try this code:

dim var as variant
dim strIDs as string
for each var in Me.lstBox.ItemsSelected
strIDs = strIDs & Me.lstBox.Column(0, var) & ","
next
if len(strIDs) <> 0 then
strIDs = Left$(strIDs, Len(strIDs)-1)
docmd.OpenReport ReportName,View:=acViewPreview,WhereCondition:="ID In (" & strIDs & ")"
end if
 

Users who are viewing this thread

Back
Top Bottom