G
Guest
How do I set up a combo box to choose which report that I want to look at or to print?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
René
One approach would be to create a form and add both a combo box and a
command button. The source of the combo box would be a list of the report
names, and the command button would run the
DoCmd.OpenReport Me!cboYourComboBox,,,
command (your syntax may vary).
A couple ways to list reports: first, using the MSysObjects table. I
prefer a second way, building a table of report information, including
Access report name, User report name (a more user-friendly version), and
whatever report criteria settings are appropriate to each report (e.g.,
display title, etc.).
One approach would be to create a form and add both a combo box and a
command button. The source of the combo box would be a list of the report
names, and the command button would run the
DoCmd.OpenReport Me!cboYourComboBox,,,
command (your syntax may vary).
A couple ways to list reports: first, using the MSysObjects table. I
prefer a second way, building a table of report information, including
Access report name, User report name (a more user-friendly version), and
whatever report criteria settings are appropriate to each report (e.g.,
display title, etc.).
L
Lewis Moseley
This is doable, using the techniques posted in the other reply.
But why not just make it EASY for your users by giving the a
"switchboard" form of command buttons, one per report? Or, if you
have a HUGE number of reports, a "report catagory" switchboard with
sub-switchboards containing buttons for the reports,
Or, in any reporting situation, you'll find that just a few reports
get the most usage. Put those on a the main report swichboard with a
"MORE REPORTS" button to go to anoter page.
But why not just make it EASY for your users by giving the a
"switchboard" form of command buttons, one per report? Or, if you
have a HUGE number of reports, a "report catagory" switchboard with
sub-switchboards containing buttons for the reports,
Or, in any reporting situation, you'll find that just a few reports
get the most usage. Put those on a the main report swichboard with a
"MORE REPORTS" button to go to anoter page.
P
Paul Johnson
If all you want to do is choose a report to print, then the Access database
window is the easiest interface to use. I'm wondering if you really wanted
to ask how to use a combobox to open a report on a specific record?
Paul Johnson
window is the easiest interface to use. I'm wondering if you really wanted
to ask how to use a combobox to open a report on a specific record?
Paul Johnson
or to print?René said:How do I set up a combo box to choose which report that I want to look at