Report Using Input on Form

[andresdm]

Hello,



I have a form where I want Access take the open record ID (called ClaimsLog.CL_Claims_ID) and use it as a filter in a report to only show comments around the CL_Claims_ID.

Example, for Claim ID 37, I want a macro that will spit out a report with comments only for that Claim. How do I do this?

[June7]

I don't use macros, only VBA.

DoCmd.OpenReport "report name", , , "CM_Claims_ID=" & Me.CM_Claims_ID

[andresdm]

The VBA kinda works. I shows the comments of the open record, however, it keeps printing it and not displaying the report. Do you know why?

[June7]

Print output is default for OpenReport. You must specify otherwise by argument parameter.

Read up in VBA Help on using OpenForm and OpenReport methods to get familiar with their various arguments and optional parameters.