open report

[krishnanhemanth]

hi everybody

i need a report to be printed from a form

the form has a button that opens another form called "invoice print"

the invoice print form has 4 yes/no check boxes

there a 4 reports that needs to be corresponded to this 4 check boxes.

what i want is
the user should be able to check the required boxes and if he presses the ok button, all those reports need to be printed

please help
hemanth

 

[boblarson]

You can use something like this in a click event of a command button:

If Me.chkYourFirstCheckBoxNameHere Then
   DoCmd.OpenReport "ReportNamehere"
End If
 
If Me.chkYourSecondCheckBoxNameHere Then
   DoCmd.OpenReport "SecondReportNameHere"
End If
 
...and so on

 

[krishnanhemanth]

thanks boblarson for your time and idea

i did it using the if statement and it is half baked right now
what i did was
i put a print button on my invoice form
when the user clicks the "print button" another form opens.this form gives the option to the user to check the boxes that needs to be printed.

i have managed this part

tha part iam stuck is that the report needs to be filterd with respect to the data available on the form that is open
that means, if the invoice form is showing the data of invoice no 10, then the report needs to be filterd and opend to print invoice no 10

please help