I have to say, I really enjoyed reading this post. You two made me laugh. I am planning to do the same sort of thing. I am working on stream lining reports for my application, so that I don't have a huge maze of menus.
I will have to have a report menu with one button for detailed reports, and one for summary(statistic) reports.
I had a couple of questions about applying this process to my application, and I was hoping one (or both!) might be able to help answer them for me.
I am thinking that this could work for the statistic report menu. My database is normalized, so I can't use their names in the combos. Is there a way to give them 'nice names'?
This has another part to it too. My application is for people who apply for a job at my work. Because of that I have summary report for candidates and for hires. parallel reports, but one for (ie) all candidates by the office that they applied to. Then I would have one for all hired candidates (were hired) by the office that they were hired to. Same with department, and many others.
I would like to do somethnig like what you have and it would end up looking like this:
Form would have one combo to choose candidates or hires. A second combo would be to choose the category for the desired numbers. There is a master statistic report that will be 1 for candidates and 1 for hires. I do not think the user will ever want to print all reports.
Oh that reminds me. I only want to set to preview reports. they will print if they really need to.
Thanks.
