Form printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sirs,
I have a form with three subforms.
One of those subforms includes the Invoice number.
In the moment, if I want to print the mainform I have to print all.
I would like to print only those main forms where the subformes includes an
invoice number.
How can I do that?
Thanks
Klaus
 
Hi Klaus,

You should use a report for printing, not a form

If you have a form to show what you want on a report, here is a quick
way to make a report:

go to design view of form and blank report
1. use same RecordSet as for form
2. copy all controls from form and paste onto report

do the same for the subreports and link them using LinkMasterFields and
LinkChildFields

Then you can modify the recordset of your main report to only include
those records...

add the invoice table to the RecordSource and set up a join such that
you will only see the main records if there is an invoice record

~~~~ RecordSource Property ~~~~

from the design view of a report or form:

turn on Properties
(from menu: View, Properties)

select the report or form
(click in the upper left where the rulers intersect)

click on the Data tab in Properties window

there you will see the RecordSource property
once you click in the property, you will see the builder button ... to
the right

If your report is based on a query, this takes you to the query design
screen

If your report is based on a SQL statement, you can modify it like the
design view of a query (you can also press SHIFT-F2 to use the Zoom Box
to change the SQL)

If your form or report is based on a table, you will be asked if you
want to make a query

Make the desired changes and then, when you close, Access will ask if
you want to update the SQL.


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hi Crystal

Sorry my mistake I spoke from a form but actually ment a report.
So, I have a report.
Can I use the same procedure as you told or is there something easier?
Regards
Klaus
 
Hi Klaus,

if I am understanding your situation, since you already have your
report, all you have to do is modify the RecordSource property of the
main report to just get records with invoices (don't show anything from
the invoices table, just add it and link it).


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top