multiple reports

[eddcole]

Hi there

Is there a way you can choose what report to run without filling the screen with buttons

I have over 50 reports to chose from but do not want a button for all of them. Can this be done with a text box and 1 button? If so, how?

Thank you

Edd

 

[Ranman256]

put your report names in a table, I use
[caption],[report],[batch]

make a form with a list or combo box.
user selects the report, click open button
docmd.openreport cboRpts, acpreview

caption is what the user sees
report is the actual name of the report to open, (the combo is set to this field)
[batch] in case you want to show reports for different forms or departments. a filter.

 

[eddcole]

Thank you, so simple when you know how