Printing based on ID

B

BTings187

Hello,

I'm not sure if this is the appropriate place for this question, so I
apologize if it is not.

I have several reports in Access 2003 and they all contain a primary key
field (ID). I would like to print out one copy of each report based on this
primary key identifier (ie. print out "report A" with ID 123, "report B" with
ID 123, "report C" ...etc). Is there any way I can set up Access to do this
with any given ID that I may require?

Thanks for your help!
 
M

Mike Labosh

I'm not sure if this is the appropriate place for this question, so I
apologize if it is not.
Click to expand...

Yup, you're in the right place.
I have several reports in Access 2003 and they all contain a primary key
field (ID). I would like to print out one copy of each report based on
this
primary key identifier (ie. print out "report A" with ID 123, "report B"
with
ID 123, "report C" ...etc). Is there any way I can set up Access to do
this
with any given ID that I may require?
Click to expand...

You can have the query the reports are based on have a parameter for ID that
it uses as a criterion. Then, to run them, pass the desired value from a
control:

DoCmd.OpenReport MyReport, acViewNormal, , txtID.Text
 
R

Roger Carlson

Top