printing a report

[JaredNJames]

hi, i have button on a form which prints a report.

can anyone post the code required to get the report to print.

report name : qry_invoice

i just cant suss it out.

my current code is:
DoCmd.OpenReport "qry_invoice", acViewPreview, , , acHidden
DoCmd.RunCommand acCmdPrint

but that just prints the form.

Jared James

 

[Rich]

DoCmd.OpenReport "qry_invoice", acNormal

 

[JaredNJames]

may have forgot to mention, i dont want the form to open. and i dont believe that code prints it, just opens it.

 

[JaredNJames]

hi, nevermind sorted it now, you were right, just added hidden on the end.

thanks
jjames

 

[Rich]

Form or Report?

 

[JaredNJames]

report, nice one mate