Printing multiple copies of a form

[Rob Mulligan]

Dear All,

I hope someone can point me in the right directions please.

I have an Access based CRM system that was built for me in 1998. Amazingly it is still pretty effective. However, I would like to make a small adjustment in the programming..

Once we've added the details for an order we press continue and the screen closes and one copy of the acknowledgement of order form. I simply want it to print three copies!

I believe this is the coding part of the command that is effected.

Rem Print Report
DoCmd.OpenReport "Order Acknowledgement"

Rem Close Form
DoCmd.Close acForm, "Booking Entry"

I hope someone can help and i look forward to hearing from you.

KR

Rob

 

[MarkK]

Just do it three times . . .

Rem Print Report
DoCmd.OpenReport "Order Acknowledgement"
DoCmd.OpenReport "Order Acknowledgement"
DoCmd.OpenReport "Order Acknowledgement"

Rem Close Form
DoCmd.Close acForm, "Booking Entry"

Cheers,

 

[Rob Mulligan]

Thanks Markk,

Worked a treat. I did say I wasn't a programmer!

KR

Rob