command button on form to run totals report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Is it possible to automatically run a report from a form.I already have a report that uses a query to run a two column totals sum report, i would like the form to have a comman button so the dat entry person could just click at the end of the day and the report would run.Thanks
 
Hello,

Is it possible to automatically run a report from a form.I already have a report that uses a query to run a two column totals sum report, i would like the form to have a comman button so the dat entry person could just click at the end of the day and the report would run.Thanks
Click to expand...
To run and print out the report without preview, code the command
button's click event:
DoCmd.OpenReport "ReportName"

To preview the report, code
DoCmd.OpenReport "ReportName", acViewPreview
 
open your form in design view. make sure the Control Wizards toolbar button
is selected. then add a command button to your form - the wizard will open
automatically. follow the prompts, and the wizard will write the code to
open your report, for you.


joe said:
Hello,

Is it possible to automatically run a report from a form.I already have a
Click to expand...
report that uses a query to run a two column totals sum report, i would like
the form to have a comman button so the dat entry person could just click at
the end of the day and the report would run.Thanks
 
Back
Top