Create a form that allows you to find the record. Then add a command button
that opens a report filtering on that record. Then modify the code to open
additional reports.
I am not as proficient as I wish in access can you please provide more
detailed information. I can adjust code for each of the remaining reports
but I need the lead report commands and code and a transition to the next
report
Thank you