Print individual forms

  • Thread starter Thread starter Radhika
  • Start date Start date
R

Radhika

I have created a form with several subforms in it. The form contains the same
information for a number of different individuals. I would like to print the
form for each individual separately. When i try to print it, if prints out
the information for all the individuals. How do i do this. I have attached a
screen shot of the first page of the form.
 
The problem is that forms are used for user interface, and have things like
buttons, radio controls etc. that often hinders the ability to print a form.

furthermore you'll often find that the form has background sheeting, and I
can waste a lot of ink.

I'm going to suggest that you build a report that mimics, or looks very
similar to your form. And for the sub forms, it you can use the same sub
forms in the report, or it's often better to simply create a new sub report.

You can then use the follwing code behind a buttion:

me.Refresh
docmd.OpenReprot "name of reprot",acViewPreview,,"id = " & me!id

You can eventually remove acViewPreview constant in the above command and
it'll go directly to the printer without intervention on your part. The
above assumes you have a primary key value of "id", which is the default.
 
Back
Top