printing a form from a report

[binghamw]

printing a report from a form

Hello,

I have set up a report to print right from a form. It prints whatever records are displayed on the form.
I thought it was working perfectly, until I realized that it was printing the same report over 11 times!
When you view it in print preview, there are 11 pages, but there should always be just one!

Help please!

 

[Dave Eyley]

Well, my guess is that you haven't told the report which record you want printed and there are 11 records in you table....

You should be using the statement -


DoCmd.OpenReport "MyReport",acViewNormal,,"[PrimaryKey]=Forms!MyForm!PrimaryKey"


This should limit the print to the one on the form.
Make sure that the form is a Single Form and not a Continuous Form.

HTH

Dave Eyley

 

[binghamw]

Thank you SO much!

That worked perfectly.