Hello everyone.
I'm working on a simple purchase order database for my place of work. I have a report containing subreport that forms a purchase order.
The main report includes the delivery address, supplier information, order number etc. And the sub report contains the order details, item description, cost etc. They are connected via the order number and everything works correctly.
I have a macro that displays a single report (rather than all of them) so you can print that order, email it etc.
OPEN REPORT
Is there a way I can get round this?
Be gentle, I'm new to all this.
Kind regards,
JB
I'm working on a simple purchase order database for my place of work. I have a report containing subreport that forms a purchase order.
The main report includes the delivery address, supplier information, order number etc. And the sub report contains the order details, item description, cost etc. They are connected via the order number and everything works correctly.
I have a macro that displays a single report (rather than all of them) so you can print that order, email it etc.
OPEN REPORT
Report Name: Purchase Order
View: Print Preview
Filter Name:
Where Condition:[PurchaseOrderTbl]![Order Number]=[Forms]![Purchase Order Reference]![Order Number]
Window Mode: Normal
The problem is, when I execute this macro it creates page for every entry on the sub-report (order details). So if I make an order which has 25 items, it creates 25 copies of the same report, all with the same information.View: Print Preview
Filter Name:
Where Condition:[PurchaseOrderTbl]![Order Number]=[Forms]![Purchase Order Reference]![Order Number]
Window Mode: Normal
Is there a way I can get round this?
Be gentle, I'm new to all this.
Kind regards,
JB