Help in Printing an Access Report

[oop94]

Hey there!
I made a form where I added two 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 and made it worse. I was also trying to 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!

 

[rjoubert]

Is your form also in Access? If so, all you need is one line of code to send the report to the printer...

DoCmd.OpenReport "ReportName", acViewNormal

 

[johnwm]

It looks like the question relates to Access VBA rather than VB6 (this forum)

Use the Find a Forum link at the head of the page to identify which of the specialist Access forums you need.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller