Reports

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
 
S

Stockwell43

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.
 
M

Matt

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.
 
S

Stockwell43

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.
 
J

Joshua A. Booker

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
 
Top