Opening = Print?

[HowardChr via AccessMonster.com]

Hmm.. I have a command button on a form have the following code: "DoCmd.
OpenReport "Hazards"". When I press the button, instead of Opening the
report, it prints it! I'm confused... any ideas?

 

[HowardChr via AccessMonster.com]

Nevermind, I forgot the ending. Should have shown: DoCmd.OpenReport
"hazards", acPreview

 

[Marshall Barton]

Hmm.. I have a command button on a form have the following code: "DoCmd.
OpenReport "Hazards"". When I press the button, instead of Opening the
report, it prints it! I'm confused... any ideas?

If you want to preview a report, then you need to specify
it.

DoCmd.OpenReport "Hazards", acViewPreview