code for opening a report

[stefanocps]

hello i need to pen a report from a button
i use this
DoCmd.OpenReport "Report", acViewPreview, "Report"


i would like to open the report in the same format as when i actually open the report , not in the print preview mode
Hod o i do that?


thanks

 

[theDBguy]

Try using acViewReport instead of acViewPreview.

 

[stefanocps]

great!
thanks a lot!

 

[theDBguy]

Hi. You're welcome! Good luck with your project.