Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

multiselect listbox

1 view
Skip to first unread message

CAPTGNVR

unread,
Apr 27, 2010, 1:09:01 PM4/27/10
to
Dear All

I have list of names and their bio data.

I am able to get the information for the multi selected persons.

What I need is - steps for using multi select, to print out individual bio
data of the persons selected for ex. say selected three persons.

Pls help. Will be watching for guidance.

brgds/captgnvr


Scott McDaniel

unread,
Apr 28, 2010, 6:06:01 AM4/28/10
to
"CAPTGNVR" wrote:

> Dear All
>
> I have list of names and their bio data.
>
> I am able to get the information for the multi selected persons.
>
> What I need is - steps for using multi select, to print out individual bio
> data of the persons selected for ex. say selected three persons.
>

If by "print out" you mean that you have a report that shows those details
and you need to print a filtered report for each selection, then you can do
this:

Dim var As Variant

For EAch var in YourListbox.ItemsSelected
DoCmd.OpenReport "YourReportName", , , , "Report_Field=" &
Me.YourListbox.ItemsSelected(var)
Next var

Obviously you'd have to change the OpenReport call to match your objects.
The "Report_Field" would be the field on your report which corresponds to
your listbox items.
See this KB article for more info: http://support.microsoft.com/kb/827423

0 new messages