removing the print box

[JaredNJames]

hi, when i press print on a form, a report is printed based on the info in the form.

is there any way to get the report to print when the print button is pressed, without have the print dialogue box appear?

jjames

 

[boblarson]

Usually

DoCmd.OpenReport "YourReportNameHere", acViewNormal

would do just that.

 

[JaredNJames]

i dont want the report to open

 

[boblarson]

You'll have to open it to print it. But, if you use that code it shouldn't stay open, it just opens, prints, and closes. If the recordset is small enough you can barely see it happen. And, if it doesn't just put in

DoCmd.Close acReport, "YourReportNameHere", acSaveNo

right after the open and it will take care of it.

 

[JaredNJames]

thanks mate