Multi-select

[Guest]

I have a list box with multi-select activated, this list boxs works great. I
need all (selected) records to be printed on one report. I guess what I
asking for is an example of code to gather all selected records and print
them on one report.

 

[Duane Hookom]

There is a generic function and sample usage for a multi-select list box at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

I really just need a few lines of code to help me. Heres what I was thinking..

Private Sub Command3_Click()
DoCmd.OpenReport "friggin report i can't print"
[something, something]. [more magic.]
print "friggin report i can't print"
DoCmd.closeReport "friggin report i can't print"
end sub.

There might be a little trouble with my code but someone has to know what I
need

 

[Duane Hookom]

There is another solution here http://www.tek-tips.com/faqs.cfm?fid=3936
that should work.


--
Duane Hookom
MS Access MVP

I really just need a few lines of code to help me. Heres what I was
thinking..

Private Sub Command3_Click()
DoCmd.OpenReport "friggin report i can't print"
[something, something]. [more magic.]
print "friggin report i can't print"
DoCmd.closeReport "friggin report i can't print"
end sub.

There might be a little trouble with my code but someone has to know what
I
need

There is a generic function and sample usage for a multi-select list box
at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Richard]

Duane,

Thanks for your tip http://www.tek-tips.com/faqs.cfm?fid=3936 I found a
great work around (on that site) with check boxes and a subform, it acts and
looks pretty much like a complicated multi-select list box except minus all
that nasty code..haha

There is another solution here http://www.tek-tips.com/faqs.cfm?fid=3936
that should work.


--
Duane Hookom
MS Access MVP

I really just need a few lines of code to help me. Heres what I was
thinking..

Private Sub Command3_Click()
DoCmd.OpenReport "friggin report i can't print"
[something, something]. [more magic.]
print "friggin report i can't print"
DoCmd.closeReport "friggin report i can't print"
end sub.

There might be a little trouble with my code but someone has to know what
I
need

There is a generic function and sample usage for a multi-select list box
at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
Duane Hookom
MS Access MVP



I have a list box with multi-select activated, this list boxs works
great.
I
need all (selected) records to be printed on one report. I guess what
I
asking for is an example of code to gather all selected records and
print
them on one report.