Utilizing Access 2016.
All this is probably pretty easy for you guys, but I'm a complete novice with grand ideas I am currently unable to implement on my own.
I have a form (splash page).
I have 8 reports that provide summary info for specific departments.
I have 8 reports that provide detailed info for same.
I have 8 reports that provide ALL data for all departments.
All reports are based on their own query's and they work just fine.
What I want is a combo box on the splash page that will allow a user to select a specific report for viewing (and printing if they so desire). I'll need three combo boxes (one for dept summary, one for dept detail, one for all) to try and keep this as button-driven and easy to navigate for the users. Users never manipulate/add/delete data... they only need to view the reports.
So.. what is the easiest way to create a combo box that will pull up a specific, selected, report? Additionally, I would like to have the reports named in the combo-box to be different than the actual report name. I would like the combo box to show/call report "ABCD", even though the report is named "ABCD_ALL_RPT".
I imagine I'll need the combo-box and a "view" button (or something similar).
All this is probably pretty easy for you guys, but I'm a complete novice with grand ideas I am currently unable to implement on my own.
I have a form (splash page).
I have 8 reports that provide summary info for specific departments.
I have 8 reports that provide detailed info for same.
I have 8 reports that provide ALL data for all departments.
All reports are based on their own query's and they work just fine.
What I want is a combo box on the splash page that will allow a user to select a specific report for viewing (and printing if they so desire). I'll need three combo boxes (one for dept summary, one for dept detail, one for all) to try and keep this as button-driven and easy to navigate for the users. Users never manipulate/add/delete data... they only need to view the reports.
So.. what is the easiest way to create a combo box that will pull up a specific, selected, report? Additionally, I would like to have the reports named in the combo-box to be different than the actual report name. I would like the combo box to show/call report "ABCD", even though the report is named "ABCD_ALL_RPT".
I imagine I'll need the combo-box and a "view" button (or something similar).