Need to print a Report

[eme126]

Hello everyone!
I made a form where I added to command buttons. The user is supposed to be able to click the command button and have the report Print. I was right-clicking on the command button and I was trying to write the code, but I am very new at this, so I think I messed it up worse. I was trying to also build a Macros and use the PrintOut command, but I could not get it done.

If someone can help me to either build a macros or write the code, I would like to first use the OpenReport command and then the PrintOut command. I just do not know how.

Thank you in advance,

Steff

 

[whitesmoke]

use code below to print on the button click
docmd.openreport acviewnormal "report name"

do a search on it in the forum. as i would recommend before placing new posts.

 

[eme126]

I cannot get it to work. I am missing some kind of ending.

 

[gregoryharvey]

hi
if you open your form in design view there's a toolbar, 11th from the left is a command buttin option. once selected and placed on the form a command button wizard will pop-up.select report operations then print report.then you will be ask for what report to print. select your report than chose how your button looks name it and your set.

 

[gregoryharvey]

hi again
if you rather the macro.in the db menu select macro, new in the drop down menu select open report.in the action arguments enter your report name, view ...etc.save it.
open your form right click on that button to get properties menu. in the event tab go down to " on click" click your mouse there and a drop down menu appear. select your macro you created and your set.

 

[eme126]

Thank you so much WhiteSmoke and Gregory. You ROCK!