We are creating a database where the user inputs data for pricing. There are
approx. 5-6 "reports" that the user can print. The can print 1 or more
reports (or all). I'm thinking of adding a command button that would open a
selection box listing the reports and allowing the user to select a report
(s) and then close once the reports print. I don't want to write any VBA if
I can figure out how to do this a simpler way. Any suggestions?
--
Thanks!
Chris

Well, let's think about this: you're going to have to write some code to open
the selection box and evaluate the choice made, so why the aversion to
'writing' the code to print the report. I'm also assuming that your database
is in Excel, not something like Access, or (heaven forbid!!) Word.

Actually you can 'write' the macros to print the individual reports by
recording macros as you go through the process of printing them one by one
and then assigning those macros to the various responses of your selection
box.

Bottom line for me is that I can't come up with a way to do this without
some VBA code somewhere.

"Chris" wrote:

We are creating a database where the user inputs data for pricing. There are
approx. 5-6 "reports" that the user can print. The can print 1 or more
reports (or all). I'm thinking of adding a command button that would open a
selection box listing the reports and allowing the user to select a report
(s) and then close once the reports print. I don't want to write any VBA if
I can figure out how to do this a simpler way. Any suggestions?
--
Thanks!
Chris