Creating Report based on List Box Selection

[infinitx]

Hi,

I have a form that has a list box that lists all of the item id's that are currently in the database.

Is it possible for the user to MultiSelect as many items as they want by item id and then click a command button that would open a report that displays only the items that the user selected in the list box?

Thanks,
Alex

 

[vknierim]

Hi,

I think this approach is possible but I don't think it's very elegant:

1. You could add a (yes/no)-field to your table which indicates whether the record should be printed.
2. Run a VB Code that updates this field to "yes" for all selected records in the list when you press the button.
3. Open/Print the report using a query that selects all records which have the "print"-field set to "yes".
4. After printing update your table, setting all "print"-fields to "no"

This should work but is not very elegant as it may involve a lot of table-manipulation.

Maybe someone else from this forum can come up with a better idea....


Regards

Volker

 

[___]

See if this is any help

 

[infinitx]

Thank You

Thank you both!

The attachment was a big help! That was exactly what I was looking for!

Thanks,
Alex