Reports

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have a report based off of a form. The form is formatted to fit all of the
info on an 8 1/2 x 11 page. When I view the report, it shows up as one long
page. The end result of what I am attempting is to click the print button on
my form, and have it print the corresponding report page. I tried to have it
bring up the corresponding info on the report in print preview even, but then
it comes out blank. Any help would be appreciated. TIA
 
Are you trying to print the current record on the form or multiple
information from your table? If the latter, you need to create a query that
feeds your report.
 
My form displays several bits of info about a particular "JobNumber". I want
a report that looks the same to print the current record on the screen so I'm
not printing forms.
 
Well, I know you can easily pull the record with a query by specifying the
Job Number. However, I not sure what the criteria is as I am not too good
with queries.

Second thing is do a search in this forum because I have seen several
posting asking the very same thing. People want to print the current record
in a report and it can be a bit complicated but I have seen the postings and
they were answered by some of the best MVPS.

Sorry I couldn't be of more help but hope you can get something out this.
 
Hi Matt,

The 'Save As | Report' option from a form will save the form design as a
report for you. However, this report will not print by clicking the print
toolbar button from the form. To print a report from the form you need to
add a button to the form design which will launch the report. The command
button wizard will walk you though launching a report and limiting the
records to print.

To use the toolbar button to print a single record from the form, you will
be printing the form rather than the report. The form prints all the
records that are displayed on the form. To print a single record, you need
to apply a filter on the form first. For example, click in your unique
field, perhaps Job Number in your case, then click the filter-by-selection
button. If nav buttons are displayed at the botton of your form, you should
see 1 of 1 (filtered). Now click the print button and you should print only
te filtered record.

I find using a repoirt is better than printing the form as you have much
better control over page setup.

HTH,
Josh
 
Back
Top