Print a report from a form

[morganpeet]

I am trying to print a report called 'Invoice' from a form showing the order details. I have set up a command button on the form to print the invoice with the event procedure as follows:


strDocName = "Invoice"
DoCmd.OpenReport strDocName, acViewPreview, , "[Invoice No]=Forms![Invoice]![Invoice No]"

When I press the print button i have a box coming up saying Forms![Invoice]![Invoice No]" and if in enter the invoice number then I can print the invoice for that number. How can i get it to work without having to manually enter the invoice number?

(I am quite new to this and have copied bits and pieces from other databases)

 

[pbaldy]

You have to concatenate the form reference. Here's an example of the 3 different syntax methods (it's the same for OpenReport):

http://www.baldyweb.com/wherecondition.htm