Report is showing all data in table, on many many pages.

  • Thread starter Thread starter PaulHilgeman
  • Start date Start date
P

PaulHilgeman

I think I have a fairly simple problem here.

I am doing a database similar to NorthWind.

In my main orders form, I have placed a button that will print a
report. It is supposed to simply print a report that is a summary of
the order, info and a subreport showing the products on the order etc.

Instead, I get a single page printed for every order I have in the
system.

How do I limit this to do just the single report for the data I have
showing in the form?

I have a feeling it is the subreport that is screwing things up here,
but I could be wrong.

I looked through several examples, but wasnt able to come up with the
answer.

Thanks!
 
Presumably you have an Orders form where you enter the orders, and there is
an OrderID primary key field to identify the order?

If so, you can put a command button on your form, to print just the order
that is showing on your form, by using the WhereConditoin of OpenReport.

For details, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
 
Easy Enough,

Alan, thanks for all of your help, you have answered about 3 or 4 of my
7 or 8 questions. You have really helped me start this project.

I have gone from thinking access was just an advanced version of excel
with reports and forms to fully realizing some of its potential.

I re-did my entire database with proper relationships between orders
and products.

-Paul
 
Well done, Paul!

That's a very encouraging response too. Getting a good relational design is
the least obvious step for people who are not accustomed to database, so you
now have the essential basis to go anywhere you want from here. That's great
to know.
 
Back
Top