Print current report (1 Viewer)

[yahazim]

I KNOW we've already discussed this, however I'm still lost. I want to print a report directly from a form. I'm using the SAME query for both the form and report.

What VB sub clause do I put in my OpenReport to make Access JUST PRINT the current report?

I'm also planning on porting this to SQL Server 2000 when I'm complete. Thank You.

JIM

 

[KevinM]

On the OpenReport line in vb, add a WHERE condition referncing the Pronmary key field on the form (this should also be included on the report) like this....

DoCmd.OpenReport "ReportName",acViewNormal,,"[IDfield]=[Forms]![FormName]![IDField]"

hth