I have one one table that houses employee info. I created 10 different
termination documents that are individual reports. I now want to be able to
print them all at once, instead of individually. Right now, they are
connected to a query asking for the employee ID # which then populates the
proper fields. Could you please show me what the code would look like for
the print button:
I will give you three of my doc names so you can use them in the code:
COBRA benefits
Exit Interview
Employee Information
thank you very much

Bonnie, the simplest way to do this would be for you to bring up the
employee you want to print in your form. The command button can then print
each of the 10 reports for the current record in the form.

For your code, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
You will have 10 lines that OpenReport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bonnie43" <(E-Mail Removed)> wrote in message
news:B505BC8C-07F8-4E58-8F20-(E-Mail Removed)...
>I have one one table that houses employee info. I created 10 different
> termination documents that are individual reports. I now want to be able
> to
> print them all at once, instead of individually. Right now, they are
> connected to a query asking for the employee ID # which then populates the
> proper fields. Could you please show me what the code would look like for
> the print button:
> I will give you three of my doc names so you can use them in the code:
> COBRA benefits
> Exit Interview
> Employee Information
> thank you very much

Oh my gosh!! I cannot thank you enough for t his information. It has opened a
new level of growth and I am really grateful. You made this easy - if you
haven't already, you should write a book. I have asked questions on here
before and it is often so techical that it leaves me frustrated. Since I am a
visual learner, your instruction was quite clear. Again, thank you it makes
the task so much easier.

"Allen Browne" wrote:

> Bonnie, the simplest way to do this would be for you to bring up the
> employee you want to print in your form. The command button can then print
> each of the 10 reports for the current record in the form.
>
> For your code, see:
> Print the record in the form
> at:
> http://allenbrowne.com/casu-15.html
> You will have 10 lines that OpenReport.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Bonnie43" <(E-Mail Removed)> wrote in message
> news:B505BC8C-07F8-4E58-8F20-(E-Mail Removed)...
> >I have one one table that houses employee info. I created 10 different
> > termination documents that are individual reports. I now want to be able
> > to
> > print them all at once, instead of individually. Right now, they are
> > connected to a query asking for the employee ID # which then populates the
> > proper fields. Could you please show me what the code would look like for
> > the print button:
> > I will give you three of my doc names so you can use them in the code:
> > COBRA benefits
> > Exit Interview
> > Employee Information
> > thank you very much
>
>