Selecting multiple reports for printing

[Sketchin]

I have a table that lists all of the reports I have in my database. I created a form with a datasheet subform that uses this table as its record source. What I want to do is have a checkbox beside every record that I can check off if I want to print or export the report. What is the best way to do this? Should I put a field in my reports table? If I do that, what is the best way to "default" the checkbox back to 0 after I close the form? I could do it with an SQL update query, but I feel like that is overkill...or is that the proper way to accomplish this?

I realize this is a fairly silly newb question, but I just want to know what the common practice for batch selection of records is.

 

[pbaldy]

This thread is marked as solved; is it not? If not, yes, you'd need a field in the table to go that way. I'd lean more towards a multiselect listbox, since the table would be problematic with multiple users.

 

[Sketchin]

Yes, I figured out how to do it. I am using a listbox like you suggested.