Report unfiltered

[ailyn]

Hi I have a simple order report with a subreport that filters the details (an order can have more than one product ordered (=orderdetail in subreport).
I usually open it with a filter on orderId =Me.OrderId, but other times I open it without the filter. The problem when I do this is that the order details shows all the details of all the orders, it seems that if I don't specify the Id it loads them all in the same form.
What I need is the report to show one record at a time, I.e. one record per page. Any idea how to do this?

 

[statsman]

Which version of Access are you using? One of the versions (it slips my mind at the moment which one it is) has a flaw that reports return to their default value (portrait, 1 inch margins) even after you save them. It requires a patch which is available on the Microsoft website to repair it.
Perhaps some kind soul will jog my memory regarding which version of Access has this problem.

 

[statsman]

Please ignore my last reply, it was for another person with another problem which I posted to you by mistake.

 

[ailyn]

No, problem. Wouldn't know a solution to my probl. by any chance?

 

[reclusivemonkey]

What I need is the form to show one record at a time, I.e. one record per page. Any idea how to do this?

In the form properties, set the "Default View" property to "Single Form" rather than "Continuous".

 

[ailyn]

sorry I put form but meant report. How do you change that with a report?

 

[reclusivemonkey]

sorry I put form but meant report. How do you change that with a report?

It depends how your report is structured. If you have one record per the detail area of your report, on the properties for the detail section, in "Force New Page", choose "After Section" or "Before Section" (depending on what you want). If you record has groupings, simply place this on the appropriate group header/footer.

I'm glad you read the post again and edited your reply ;-)

 

[ailyn]

Thaaanks!!! that did the trick!