Access 2000 - Creating reports from data in form

  • Thread starter Thread starter Pharoh
  • Start date Start date
P

Pharoh

Hi everyone. I'm having trouble getting my head around this one. Is
there a way to generate a report based on data displayed in a form. I'd
like to be able to add a command button to launch a report so that the
data in the form is 'printable'.

thanks much!
 
The simple way is to right mouse click on the form and the select save as.
Select Report in the As box and name it what you want. Put a button on your
form to print the new report.
However....
You will get all of the records in the report from the table or query of the
form even if you have a single form.
The best way is to create a new report based on the same table/query as the
form.
Place a print button on the form that will print the new report and add the
criteria to the code behind the print button that passes the record ID to the
report. If you don't know how to code, run a macro that prints the report.
It is a little easier to pass the criteria via a macro
 
Back
Top