Form totaling and printing

  • Thread starter Thread starter kelly
  • Start date Start date
K

kelly

Hi and happy new year,

Does anyone know how I i can get access to generate with
an on click event a form that will popup and fill its self
in with data from a currently open form and then print off.
I am trying to get access to print off input sheets based
on my input forms design.

Can this be done?
any examples would be great cause i am not good with the
vb side.

andy
 
Hi

You should create a report to print whatever information you want. It's not a
good idea to print forms as a substitute for reports
 
-----Original Message-----
Hi

You should create a report to print whatever information you want. It's not a
good idea to print forms as a substitute for reports
.
Click to expand...
How would I go about doing that?
Is it possible to base the report on the primary (ID No)
and have the report pull in the info and print off?
The thing is I can have only 1 sub entry and 1 total entry
or I could have 6 sub entries and 1 total entry.
I will always have 1 total entry.
I will want the report to expand to print off the 6 sub
entries followed by the 1 total entry.
Can this be done?

Thanks for the idea.
 
Hi again

Yes it is possible to base a report on the primary ID. Since I have no idea
what your underlying tables are, you may have to create a query and use it as
your recordsource where you can manipulate the data in a number of ways, such
as group by, etc, etc.

Maybe if you could let us know exactly what you expect in the report and a
better understanding of your data then maybe we could, even create the
report(s) for you.
 
Back
Top