Print more than one Report

S

Simon

I have a button on my form that prints a report,

When i press the button i want it to ask how many reports i want
printing

What is the code?

I would also like the default value as 1

Thanks

SImon
 
W

Wayne-I-M

Hi Simon just to point out that people her don't get paid for this so just
giving what you need and say - what is the code - is not normally going to
get you many answers.

but

You could add an unbound combo to your form call it cboPrintNumer

the source for the combo would be 1;2;3;4;5;6 and so on up to the ma number
of reports you want to print

On the after update event of the combo put some thing like

DoCmd.SelectObject acReport, "report name goes here", True
DoCmd.PrintOut , , , , Me!cboPrintNumber

There re other way to do this using a message box and a variable or by using
a popup form but this is the simplest method I can come up with off the top
of my head at the moment - end of the day

good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top