Printing/Previewing a Order

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

I have created a main form that has a subform. In the sub
form I input the line items. Each Order on the main form
can have multiple line items.

When I print preview an order with one input line I
receive a one page report.

When I print preview an order with 4 input lines I receive
4 identical pages. 3 input lines i get 3 pages of
identical data.

Does anyone know how I can just get the report to print
out just once.
 
You should be printing reports not forms. Your main report should not
contain the same level of details as the subreport.
 
Hi Duane,

I have attached a print icon to the form that contains the
report I want to run. I am printing the report through the
from. It comes up with the correct record but as I tried
to explain before wherever I have more than one line item
in the subreport the report prints the identical page.

EG My query for the report comes up with the data I
require eg Order No: 1 Qty 5 Desc Coke
Order No: 1 Qty 3 Pesi.
Even this is only one record when it prints it prints its
twice.

Hopefully this make sense
Mark
 
Let me put it another way... check the record source of the main report.
Does it contain just order summary information or do you also see Qtys?
 
Sorry I been away the last 2 days. The main report only
includes summary information. The sub report contains the
qty and line item iformation

Thanks Mark
 
Please disregard my previous reply. The record source is
my query. My query contains both qty line and summary
information.

Eg

Order Desc qty price
14 cans 1 1.00
15 tins 1 1.00
15 cans 1 1.00

Order No is the primary key> Order No 15 has 2 lines in
the subform. Order No 14 has only 1 line. When I print the
order the report is fine but I get two pages of identical
information
 
Did you understand that the order details must be removed from the main
report's record source?
 
Back
Top