printing from multiselect listbox

[John]

Hello. I have a situation in which users need to print labels
(barcode type) of selected parts from a multiselect listbox.
Currently, the users are printing one at a time from a continous
form. Unfortunately, the c-form is not able to be modified or an
isselected type field able to be added. So, I created a popup style
for those who will need to do a barcode label for each of the selected
parts. I have the information in the listbox (ID, PartNumber,
Revision, LotNumber). The ID width is set to 0 but is the databound
column. It is the printing that is giving me the headache. Now, the
user can select 1 or more from the listbox to print. The info in the
listbox (less the ID) is what gets printed on the barcode label. I
thought about some type of a loop that will do the selected rows, but
not getting it.

Does anyone have a sample of what can be used, a link, or even
suggestions?

Thanks.
John

 

[Allen Browne]

See:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

The article explains how to loop through the ItemsSelected to build the
WhereCondition for OpenReport.