Printing a report from a form

Hi,

I've created a database where I have a form with clients information and I also generate a report that is based on different queries. What I would like to do is print the report that matches the form of the selected client. I created a print report button, however it prints all of the reports that are created. Is there a way of printing the report that is specific to the client that is active in the form?

Thanks for any help you can give??

re: Printing a report from a form

Something like this should work...
Mary

re: Printing a report from a form

Thanks for your suggestion!! I am going to try it this afternoon!!
Thanks again!

re: Printing a report from a form

When you give a code like this, where do you post the code in order to generate your request?

re: Printing a report from a form

Typically you would create a Command Button on your form to run the report. You would put this code in the OnClick event procedure.