Printing And Selecting A Report

mitch_johnson

Registered User.
Local time
Today, 12:59
Joined
Mar 18, 2009
Messages
40
Hello, what i am trying to achieve is when i click a button in my form it loads my report up and selects the record i am currently viewing and prints the report for that record.

thanks a lot
 
The form button wizard should get you going in the right direction
 
Thanks, will that open the report to the record i am currently viewing
 
You should be able to pass a parameter when you open the report
 
Sorry could you please explain a little deeper as i am still picking all this stuff up what parameter do i need to change? thanks a lot
 
If your form is still open when you execute the print, you could in the Open_event of your report set a filter to just that record.

Code:
Private Open_Report(Cancel as Integer)
    Me!Filter = "([RecID] =" & Forms!NameOfForm!NameofControlRecID & ")"
    Me!FilterOn = True
End Sub

JR
 

Users who are viewing this thread

Back
Top Bottom