Select Records from Report to Populate Second Report

[twac1382]

Ok, so I'm really just fishing for ideas on how to make this work.

We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))

At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?

I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.

Any ideas are more than welcome.

 

[Mihail]

Add a new field (say... IncludeInReport) of type Yes/No to the table (will be a checkbox in the form).
Base the report on a query that show only the records that have the checkbox checked.
After you create the report you can run an Update query in order to clean all the checkboxes (write No in the IncludeInReport field for all records)

 

[vbaInet]

You would normally use a multi-select listbox for this sort of thing. Here's a link that should help:

http://allenbrowne.com/ser-50.html