Printing multiple but not consecutive records

[Montez659]

In my db, the user has the option of printing off what is called a "Site Visit Check List." Currently, they add the information for their Site Visits then click a button, which opens the report pre-populated and opens the print dialog. It is not uncommon for them to have to input about 20 of these at a time, and I found that they usually do not click the "Print" function until they are done adding all 20. At which point they need to go back and go through the process of the print dialog 20 or so times.

What I would like to do is have a temp table called tblPrintQueue which they will click a button and the record ID will be recorded in the temp table (displayed in a non-modal pop up form with a listbox). Then press a button and print all 20 at once.

So the question is, how would I do this? There is an existing Macro which I did not develop but did tweak a bit. I see where it tells which record to print, but I am not sure how to go about tweaking it to allow for multiple records to populate. It may need to be rewritten in VBA, and I can probably handle that.

Here is a screenshot of the existing Macro. Let me explain what I can in there. Well, it actually seems pretty self-explanatory so if you have questions let me know. Thanks in advance!

http://dl.dropbox.com/u/17000917/screenshotMacro.PNG

 

[Montez659]

In case anyone stumbles across this, here is a link that I found to help me do what I wanted to do. I needed to modify it a bit, but it works great.

http://www.baldyweb.com/multiselect.htm