I want to create a reports control panel... is there an example I can look at?

K

Kelvin Beaton

I want to create one form that the user can choose a report from a dropdown
to print.

Does anyone know of an example out there?

Thanks

Kelvin
 
C

Chris Reveille

Here is a sample process

Create a table with your report all names. Call it "Z_List_of_reports"
Create a form named "Reports"
Add a combo box to the form based on the "Z_List_of_reports" table
Name the Combo Box "Report_Selected"
Using the command button wizard add a print report button.
Select any one of you reports to print. (this is temporary)

Edit the VB code behind that button to reflect the name of the combo box
change the following
stDocName = "you report name"
to
stDocName = me.Report_Selected

Now whatever report is selected will be used for printing.
 
K

Kelvin Beaton

Very cool, thanks!!!

Kelvin

Chris Reveille said:
Here is a sample process

Create a table with your report all names. Call it "Z_List_of_reports"
Create a form named "Reports"
Add a combo box to the form based on the "Z_List_of_reports" table
Name the Combo Box "Report_Selected"
Using the command button wizard add a print report button.
Select any one of you reports to print. (this is temporary)

Edit the VB code behind that button to reflect the name of the combo box
change the following
stDocName = "you report name"
to
stDocName = me.Report_Selected

Now whatever report is selected will be used for printing.
Click to expand...
 
K

Kelvin Beaton

Ok, here's another question

I want to filter a report by the seclected item in the dropdown box

Say I want to filter by State. The dropdown would include a list of
states....

Thanks for your time.

Kelvin
 
C

Chris Reveille

in the query for the criteria for the state put
like [Forms]![NameOfForm]![NameOfTextbox]&"*"
if it is blank all states will be included
 
J

Jim Johnson

Hi Chris,

I have several similar reports that vary by product, division, etc. I am
already filtering these fields with inputs that the user must complete to
filter the reports. Is there a way to link this criteria to dropdown boxes
on a form that the user could select prior to running the report?

In this way, the user could see all the choices and select the appropriate
one instead of relying on memory? Also, the interface would speed up the
process of running 12 similar reports every month.

Thanks,
Jim
 
J

Jim Johnson

Hi Chris,

Please disregard my last post, as I was able to figure it out.

Thanks,
Jim
 
Top